> Where might I find information about optimizing inserts to MySQL tables.
In Paul DuBois's excellent "MySQL" from New Riders, there is a section about loading data efficiently in which he talks a little about inserts. In a nutshell, LOAD DATA is faster than INSERT, the fewer the indexes the faster, the shorter the statements the faster, let MySQL handle default values... and a few other things. If you're using INSERT, the syntax "INSERT INTO table VALUES(...),(...),..." is preferred because it allows you to batch multiple inserts. Which leads me to a follow-on question for Paul if he's reading. If batching is not an option, is this syntax still faster than "INSERT INTO table SET col=value,..." ? I'm working on an OO app and would like to use the objects for batch imports & exports. I know this will be slower, of course, but the table relationships are rather complex, the objects are stable and debugged and I'd rather not introduce a new uncertainty, especially since import/export will be used rarely. That said, the objects' insert methods use the "SET col=value" syntax and I'm wondering if I should re-write them to use the "VALUES(...)" syntax. I'd rather not do that if there's no performance benefit. -Derek PS This book is my bible for MySQL and I highly recommend it. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
