[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)"
with one execution

should i call the execution of the insert after each insert command?

More information about the thelist mailing list