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

"rkherath" <rkherathdisscussdotnet (AT) yahoo (DOT) com> wrote

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

http://msdn2.microsoft.com/en-us/library/ms188365.aspx

http://msdn2.microsoft.com/en-us/library/ms188609.aspx

http://msdn2.microsoft.com/en-us/library/ms175937.aspx