October 27, 2004 at 8:26 am
I’m new so forgive my use of incorrect terms. I’ll do my best to describe the situation. I have a process in a VB6 application which inserts a large number of records into SQL Server 7 data tables. After having moved the SQL from the application into Stored Procedures, it still takes a considerable amount of time to process, but it is in the acceptable time range. There is one UPDATE in the SQL, but at this time it is necessary.
The problem is there is a performance loss when multiple users run the process. When two users are running this procedure concurrently, the processing time almost doubles. Three users slow it down almost to almost triple. This is a big problem considering this will be used by possibly 50 users concurrently. Can anyone steer me to a possible solution? Any and all responses are greatly appreciated.
Tracey
October 28, 2004 at 8:21 am
Tracey - your question is rather vague. Briefly some things that need to be known to even take a stab at helping you.
1. Design of the SQL table(s) into which the data is being inserted
2. Does the table have a clustered index
3. The code snippet that appears to be the problem
Then maybe someone can take a shot at giving you some guidance
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply