Re: Sql Server 2000 slow

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: James Chang (james.chang_at_quest.com.au)
Date: 05/27/04 

Date: Wed, 26 May 2004 17:06:02 -0700

Thanks William.
I am working on the problem now.
Something I have noticed with the testing I have done:
An insert command following another insert command is relatively fast.
An insert command following a select command seems to be much slower.
All of the command objects are already instantiated so that shouldn't be the problem.
I am using SqlCommands with Fill for selects and ExecuteNonQuery for Inserts/Updates/Deletes.
Would this have something to do with sql server or with .NET?

Relevant Pages