We currnetly have a stored procedure that inserts several hundred thousand rows(close to 1 million) and it takes a while to run. We have pretty much optimzed the stored procedure and can not do anything else to it to help performace. My question is what if the data was put into a dataset with a data adapter, worked on disconnected and them using the adapter, updated or inserted back into the database? Would this be faster by chance? And I supposed the new rows or information created would depend on the client rather than the server, but I am womdering if it would still be faster.

Any other suggestions would be helpful also. Incidentily, our server is a 4 processor 2.4 gig with 2 GB of memory - so it is pretty descent.

Thanks!