Value set limitations on MySQL INSERT?
Trying to find any information on this via google is ridiculous, considering the term "LIMIT" can be part of almost any MySQL statement...
I'm curious if there's an upper limit to the number of value sets you can include in a single INSERT, for eg;
INSERT INTO `table` (row_one, row_two) VALUES ('x', 'x'), ('x', 'x'), ('x', 'x'), ('x', 'x'), ('x', 'x') .....
I noticed that when you do an SQL dump from phpMyAdmin it iterates a new INSERT every 200 rows or so, but the number varies, give or take 15 rows. So I'm assuming this is just to keep your import from timing out more than following any rigid rules.
Anybody here know?
These could all be causes: timeout regulations, max server load, general style, page breaks..
Yeah, I'm willing to presume that timeouts are the biggest enemy of large insert statements. S'all good, without knowing for sure I just went ahead and wrote a little function to split it up for me. Maybe one day I'll throw a thousand at it and see if it can take it. :)
There of course is a limit but when i tried researching this i found nothing.
I did a import a few days ago to do a mass update on 7.7mil products. i did a 1000 at a time i think possibly higher.
I must admit they did not contain alot of information 2 rows doing one row the the other. but it seemed to run fine. You can possibly chuck alot at it but you just have to be realistic in the end. With my imports i do chunks of 100 too for performance it works perfectly.
If you really want to test it, you will just have to keep putting tests through and see when it chokes.
|All times are GMT. The time now is 02:00 PM.|
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0