Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Should I Ue Bulk Inserts For A Large Table?

forums › forums › SQLyog › Using SQLyog › Should I Ue Bulk Inserts For A Large Table?

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • December 1, 2010 at 1:23 am #12177
      Joseph
      Member

      Importing Option – Should I ue Bulk Inserts for a large table?

      The table is about 300 MB in size after being exported to a txt file from the source db

      Which optino should I select? (In the export Data as Batch Script Wizard)

      Generate bulk INSERT statement

      Generate complete INSERT statement

      Generate INSERT DELAYED statement

    • December 1, 2010 at 5:51 am #31621
      ashwin
      Member

      Hi Joseph,

      Quote:
      The table is about 300 MB in size after being exported to a txt file from the source db

      Which optino should I select? (In the export Data as Batch Script Wizard)

      Generate bulk INSERT statement

      Generate complete INSERT statement

      Generate INSERT DELAYED statement

      You can use the “Generate Bulk INSERT statement” option. When this option is checked data from more rows will be written into a single INSERT statement. Each INSERT statement will be allowed to grow to the size specified in the 'Max. size of BULK INSERTS' setting.

      And to know about the settings that should be taken into consideration when specifying BULKS, you can refer the FAQ link:

      http://www.webyog.com/faq/content/24/101/en/about-chunks-and-bulks.html

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.