[thelist] quick sql performance question

Brian Cummiskey brian at hondaswap.com
Thu Sep 20 12:48:50 CDT 2007


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?



More information about the thelist mailing list