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?
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.
>
>
>
>At 12:55 PM 12/10/2002 -0500, Fernando Grijalba wrote:
> >Have you try this:
> >
> >dbConn.Execute("INSERT INTO tblname(fld1, fld2) VALUES(val1,
> >val2),(val1,val2),(val1,vla2);")
> >
> >JFernando
> >** sql **
> >
> >-----Original Message-----
> >From: Michael She [mailto:michael.she@stripped]
> >Sent: December 10, 2002 12:08
> >To: Fernando Grijalba
> >Cc: MySQL Help
> >Subject: RE: ADO Bulk Inserts
> >
> >
> >Same table, but it shouldn't matter right?
> >
> >I'm getting a SQL syntax error once I start combining my statements
> >together. If I submit the statements separately they're OK.
> >
> >
> >
> >At 09:59 AM 12/10/2002 -0500, Fernando Grijalba wrote:
> > >Are the inserts to the same table or different tables and columns?
> > >
> > >JFernando
> > >** sql **
> > >
> > >-----Original Message-----
> > >From: Michael She [mailto:michael.she@stripped]
> > >Sent: December 9, 2002 14:56
> > >To: MySQL List
> > >Subject: ADO Bulk Inserts
> > >
> > >
> > >Hi All,
> > >
> > >
> > >Does MySQL allow for Bulk Inserts via ADO?
> > >
> > >I can get a single insert statement to be inserted, but if I try t
> > >concatenate multiple inserts, I get a sytax error.
> > >
> > >I tried putting a space between each statement, return charater,
> > >semi-colon, etc, but it doesn't work.
> > >
> > >I'm doing the inserts through a ADODB.Connection.
> > >
> > >Thanks.
> > >--
> > >Michael She : michael.she@stripped
> > >Mobile : (519) 589-7309
> > >WWW Homepage : http://www.binaryio.com/
> > >
> > >
> > >
> > >---------------------------------------------------------------------
> > >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 <mysql-thread127036@stripped>
> > >To unsubscribe, e-mail
> > ><mysql-unsubscribe-fernando=ggtours.on.ca@stripped>
> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > >
> > >
> > >
> > >---------------------------------------------------------------------
> > >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 <mysql-thread127109@stripped>
> > >To unsubscribe, e-mail
> > ><mysql-unsubscribe-michael.she=binaryio.com@stripped>
> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >--
> >Michael She : michael.she@stripped
> >Mobile : (519) 589-7309
> >WWW Homepage : http://www.binaryio.com/
> >
> >
> >
> >---------------------------------------------------------------------
> >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 <mysql-thread127124@stripped>
> >To unsubscribe, e-mail
> ><mysql-unsubscribe-fernando=ggtours.on.ca@stripped>
> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
> >
> >---------------------------------------------------------------------
> >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 <mysql-thread127130@stripped>
> >To unsubscribe, e-mail
> ><mysql-unsubscribe-michael.she=binaryio.com@stripped>
> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>--
>Michael She : michael.she@stripped
>Mobile : (519) 589-7309
>WWW Homepage : http://www.binaryio.com/
>
>
>
>---------------------------------------------------------------------
>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 <mysql-thread127137@stripped>
>To unsubscribe, e-mail
><mysql-unsubscribe-fernando=ggtours.on.ca@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>---------------------------------------------------------------------
>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 <mysql-thread127144@stripped>
>To unsubscribe, e-mail
><mysql-unsubscribe-michael.she=binaryio.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Michael She : michael.she@stripped
Mobile : (519) 589-7309
WWW Homepage : http://www.binaryio.com/
