Remember, the db server has to update the index as well as the table. I've
seen some folks try to speed up reporting on surveys (is this a survey?) by
adding indexes willy nilly. Make sure your talbes have primary keys, make
sure the datatype chosen is appropriate for the data (ints are always a good
choice for yes/no data) and make sure you haven't indexed every possible
column or combination of columns. Also make sure that the clustered index
makes sense for the repetetive inserts. It's nice to be able to specify a
clustered index on your most used column - but it can kill insert queries
because a clustered index is the sort order of the table. As you insert the
table is "resorted" over and over.
-Mark
-----Original Message-----
From: Greg Czechowicz [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 12, 2004 2:53 PM
To: CF-Talk
Subject: Threads taking over 10 seconds
I have looked in our logs, and we have a Ton of threads taking more
than 10 seconds. I am talking like 500 a day. These are simple insert
queries as well. Anyone know how I can alleviate this. Our server gets
around 600 concurrent users and we have a lot of basic inserting to yes /
no questions that we ask users. I am using SQl server 2000 with cfmx 6.1
with the latest updater installed. I would appreciate any help. our
server is a 2.4 amd server with 2 gb of ram.
Thanks,
Greg
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
