SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Wizard
    Join Date
    Nov 2003
    Location
    United Kingdom
    Posts
    2,120
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Is one big mysql insert quicker or just the same speed as a Load Data Infile insert?

    Hi,

    I have made a script so that it does one bulk insert of 1,000 rows at a time. Would using Load Data Infile on the same 1,000 rows be quicker or just the same speed when uploading data to the database? And if so, then how much faster would it rougthly be?

    I have looked high and low, but could not find anything about this. In MySQL it says that it can be up to 20 times faster, but that is for single insert for each row. I am doing just one large insert and not individual inserts per row.

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    have you tried benchmarking it yourself?


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •