Database INSERT Command -
04-01-2005
, 02:41 PM
I'm writing a program that needs to use a database and I'm inserting a lot of
information into a database all at once. My program creates about 7,000
INSERT commands that need to be preformed all at once. It's taking about 2
and a half hours to complete all of these INSERT commands. Is this normal?
Is there any way to do it faster?
(Note - it's not my programming that's causing it to take so long. The
program creates all these commands, then executes them. Creating them takes
less than one second - executing them is taking hours.)
I need to run this program about 300 times to get everything entered into
the database, so I'm looking at this taking forever to get everything updated. |