List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:December 11 2002 5:00am
Subject:RE: ADO Bulk Inserts
View as plain text  
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.

Thread
Select * From table where name Like 'help'; HelpBeauford.20039 Dec
  • Re: Select * From table where name Like 'help'; HelpJocelyn Fournier9 Dec
  • Re: Select * From table where name Like 'help'; HelpRobert Citek9 Dec
    • Re: Select * From table where name Like 'help'; HelpBeauford.20039 Dec
      • Re: Select * From table where name Like 'help'; HelpBenjamin Pflugmann9 Dec
    • Re: Select * From table where name Like 'help'; HelpBeauford.20039 Dec
      • ADO Bulk InsertsMichael She10 Dec
        • RE: ADO Bulk InsertsFernando Grijalba10 Dec
          • RE: ADO Bulk InsertsMichael She10 Dec
            • RE: ADO Bulk InsertsFernando Grijalba10 Dec
              • RE: ADO Bulk InsertsMichael She10 Dec
                • RE: ADO Bulk InsertsFernando Grijalba10 Dec
                  • RE: ADO Bulk InsertsMichael She10 Dec
                    • RE: ADO Bulk InsertsPaul DuBois11 Dec
                      • RE: ADO Bulk InsertsMichael She11 Dec
                        • RE: ADO Bulk Insertsed11 Dec
                        • RE: ADO Bulk InsertsPaul DuBois11 Dec
      • Re: OT Select * From table where name Like 'help'; HelpMichael T. Babcock10 Dec
      • Re: Select * From table where name Like 'help'; HelpAndy Bakun10 Dec
      • Re: Select * From table where name Like 'help'; HelpBenjamin Pflugmann10 Dec
    • Re: Select * From table where name Like 'help'; HelpBeauford.200310 Dec
      • Re: Select * From table where name Like 'help'; HelpAndy Bakun10 Dec
      • Re: Select * From table where name Like 'help'; HelpRobert Citek10 Dec
    • Re: Select * From table where name Like 'help'; HelpBeauford.200310 Dec
  • Re: Select * From table where name Like 'help'; HelpBeauford.20039 Dec
RE: ADO Bulk InsertsAlan R Anderson11 Dec
  • RE: ADO Bulk InsertsMichael She11 Dec