HighTechTalks DotNet Forums  

Database INSERT Command

Dotnet VJSharp microsoft.public.dotnet.vjsharp


Discuss Database INSERT Command in the Dotnet VJSharp forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Cpierswim
 
Posts: n/a

Default 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.

Reply With Quote
  #2  
Old   
Cpierswim
 
Posts: n/a

Default RE: Database INSERT Command - 04-01-2005 , 09:41 PM






Here's an update:

I ran the program. This time it crated 22,833 "INSERT INTO" SQL Commands.
It took just over 6 hours 55 minutes to execute the program for an average of
0.018 seconds per command. Is this to be expected?

Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.