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:michael.she@stripped]
>>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.
