October 23, 2006 at 1:19 am
hi,
can anybody solve my query.
i have database that maintains resumes.when it has 2000 records the searching speed is good as it takes 3 secs and now i have 20,000 records.how can i query it to improve the performance of server so that it takes less time like when the database has 20,00,000 records.
October 23, 2006 at 1:59 am
hi
do u have proper indexes. if not create them
if u have proper indexes then make sure they are not fragmemented. 20,000 records is not much after all.
"Keep Trying"
October 26, 2006 at 11:38 am
Here's my 'short list' for tuning:
Round I
DBCC UPDATEUSAGE
UPDATE STATISTICS (with FULL scan) for all tables
exec sp_recompile for all tables
exec sp_refreshview for all views
Round II
DBCC DBREINDEX
UPDATE STATISTICS (with FULL scan) for all tables
exec sp_recompile for all tables
exec sp_refreshview for all views
Round III
Profiler
Query Hints
Hint: Write scalable code to start with !
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply