Home All Groups Group Topic Archive Search About

SQL Server - Concurrent update

Author
30 Jun 2006 9:45 AM
Microsoft
Hi,

I am using OPEN STA to test web based application which uses SQL server as
backend.
My problem is the database update takes longer time even after completeing
the processs.

approx. it took 45mins for 100 symultaneous updates to be completed.
here I'm using stored procedures to update the table.

how do i make the updates happen immediately without any time delay...

dnk.

AddThis Social Bookmark Button