Slow insert response time

From: Bruce Parker (BruceParker_at_discussions.microsoft.com)
Date: 07/07/04 

Date: Wed, 7 Jul 2004 10:58:18 -0700

We have a table that contained approximately 800,000 rows of information. Insert/Update operations to this table slowed down to the point the command timeout of 30 seconds was occuring. Removing about half of these rows improved the performance dramatically. I am suspecting the design of the table is incorrect. The table has 67 fields There are six fields that make up the primary key - smallint, smallint, smallint, datetime, smallint, datetime.

Could someone please explain if the table design is the issue and how it is causing problems with insert/updates?