[thelist] quick sql performance question

Chris Anderson Chris at activeide.com
Thu Sep 20 13:11:20 CDT 2007


The first would be quicker overall (except with semi-colons)
But faster still would be a BULK INSERT


-----Original Message-----
From: "Brian Cummiskey"<brian at hondaswap.com>
Sent: 20/09/07 19:00:18
To: "thelist at lists.evolt.org"<thelist at lists.evolt.org>
Subject: [thelist] quick sql performance question

which is the better method?

I have about 2000 inserts to do which comes in from a web service.


should i do

sql = "insert into TABLE (x, y, x) VALUES (a,b,c)"
sql = sql & "insert into TABLE (x, y, x) VALUES (a,b,c)"
etc
with one execution

or,
should i call the execution of the insert after each insert command?
-- 

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester 
and archives



[Message truncated. Tap Edit->Mark for Download to get remaining portion.]

-----Unmodified Original Message-----
which is the better method?

I have about 2000 inserts to do which comes in from a web service.


should i do

sql = "insert into TABLE (x, y, x) VALUES (a,b,c)"
sql = sql & "insert into TABLE (x, y, x) VALUES (a,b,c)"
etc
with one execution

or,
should i call the execution of the insert after each insert command?
-- 

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt ! 





More information about the thelist mailing list