0 Replies Latest reply: Jan 13, 2015 11:24 AM by Paul Madden RSS

    Expressor Write Table: Normal vs. Bulk Load

    Paul Madden

      In an attempt to understand Expressor better, I was wondering if someone could provide some information on the differences between 'Normal' and 'Bulk Load' in a Write Table Operator (or point me to some resources that explain it better).  The help file states:

       

      • Normal mode writes (inserts) records to the table.
      • Bulk mode writes (inserts) multiple records as a group to the table


      It also states that Database Errors are not handled by the Write Table Operator when Bulk Load is set. And Partitioning is not supported in Bulk mode.  But I've found nothing that tells me exactly how they are they are different, mechanically.

       

      How are their INSERTS mechanically/functionally different?

      What are the pros and cons of each?

      Does one have better performance?

      Are there situations where one is better than the other?

       

      Any information is appreciated.  Thanks!