SitePoint Sponsor |
|
User Tag List
Results 1 to 2 of 2
-
Dec 26, 2005, 05:00 #1
- 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.Affiliate Programs Directory - Over 3,000 Programs.
----> 150+ CPA Networks | Earn upto $.75 CPM on Banner Ads
-
Dec 26, 2005, 10:12 #2
- 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