At 15:07 -0500 12/10/02, Michael She wrote:
Apparently, aren't bulk inserts faster?
I'm currently looping my insert statements, but from what I read, a single bulk insert should be faster?
Can anyone confirm this?
Yes, a single bulk insert will be faster.
Also, the reason your "multiple statements separated by semicolons" approach fails with a syntax error is that the client server protocol does not allow you to send multiple statements in the same string. Indeed, you might even get a syntax error by adding a semicolon to the end of a string containing a *single* query, because semicolons are not actually part of any SQL statement syntax.
At 02:49 PM 12/10/2002 -0500, Fernando Grijalba wrote:Why do you have to do it that way? Could you do it in a loop? Do Until rst.EOF dbConn.Execute("INSERT STATMENT"); Loop JFernando ** sql ** -----Original Message----- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 10, 2002 13:55 To: Fernando Grijalba Cc: MySQL Help Subject: RE: ADO Bulk Inserts Hi, That is how I currently submit my statements, but can't I go: Hi, that is how I execute my current statements. But can't I submit multiple statements like: "INSERT INTO tblname(fld1) VALUES(val1);INSERT INTO tblname(fld1) VALUES(val1);"? If I submit multiple statements I get a SQL error.
--------------------------------------------------------------------- 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
