File parsing and insert data into data base

[vaskarbasak]

Hi friends,

I have a 500 zip file. I am trying to read the zip file .Then insert the data in to DB .But it is taking long time. I have to insert all record into DB with in 1 hr.

please help me...

Thanks
Vaskar

[BigDaddyLH]

The first step is to profile execution and find out how much time each separate step is taking. No sense trying to speed up something that's 0.01% of your execution time.