Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
achaudhri
Starting Member
1 Post |
 Posted - 2008-06-02 : 11:30:17
|
| I had a database of electronic resources which had 28000 records earlies and was working fine. Now we have added a whole bunch to make it 800K records which has increased the search time to 14-22 seconds which is not acceptable. I have all the tables indexed.Please help me how to solve this problem. Let me know what other information I should put up here to make my problem undestandable.Thanks in advance,Archana |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-02 : 21:29:21
|
| How often do you rebuild indexes/update statistics? Do your queries use proper index? |
 |
|
|
bdloving
Starting Member
4 Posts |
Posted - 2008-07-17 : 10:23:03
|
| What kind of searches? |
|
|
|
|
|
|
database search time -too long