C# application takes a long time to run

C# application takes a long time to run

Post by cmtoZXJhdG » Thu, 05 Apr 2007 17:06:04


Hi,

I have a program which runs without any error. What it does it reading
records from a dBase table and write in sql tables. I have 112*8 tables to
reads. and fill in to 8 sql tables. it has more than 1000000 records. it
takes more than 5 hours to run.

i want ot make my application faster. please help me.

regards
--
rkherath
 
 
 

C# application takes a long time to run

Post by pvdg4 » Thu, 05 Apr 2007 21:14:49


Look into Bulk Insert. Here are a couple of links to get you started.

http://www.yqcomputer.com/

http://www.yqcomputer.com/

http://www.yqcomputer.com/