[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