Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
improving performance (INDEXING)
1 view
Skip to first unread message
EJ Legarda
Nov 15, 2001, 4:43:44 PM11/15/01
to
I have done a web application using asp and MSDE. The DB is
experiencing occasional slowness, specially when I am inserting
several records.
Here is the scenario:
Table with fields ID(identity), CandidateID(integer),
ExpertiseID(integer).
I have several other tables with similar structure, and I am almost
certain that these tables are the ones causing the slowness. I think
it has something to do with Indexing. Need your help, Thanks!
experiencing occasional slowness, specially when I am inserting
several records.
Here is the scenario:
Table with fields ID(identity), CandidateID(integer),
ExpertiseID(integer).
I have several other tables with similar structure, and I am almost
certain that these tables are the ones causing the slowness. I think
it has something to do with Indexing. Need your help, Thanks!
Ross Lourensse
Nov 15, 2001, 5:33:26 PM11/15/01
to
try using the index tuning wizard
"EJ Legarda" <e...@4miles.com> wrote in message
news:e1bbcf58.01111...@posting.google.com...
Paladin
Nov 16, 2001, 1:43:21 AM11/16/01
to
How many records are we talking about?
Are there triggers on the tables?
Inserts dont really benefit from indexes, they tend to suffer from them.
The indexes are left alone because every other process that tries to locate
records benefits greatly from them.
Are there triggers on the tables?
Inserts dont really benefit from indexes, they tend to suffer from them.
The indexes are left alone because every other process that tries to locate
records benefits greatly from them.
How many rows (round estimate) are there to deal with?
-Paladin
"EJ Legarda" <e...@4miles.com> wrote in message
news:e1bbcf58.01111...@posting.google.com...
0 new messages