unhappy_mage
[H]ard|DCer of the Month - October 2005
- Joined
- Jun 29, 2004
- Messages
- 11,455
Hi guys,
I notice that searches are very slow, 30+ seconds in cases where many results will be returned. Examples:
Search main forums for "amd", 60 seconds.
Search Disk Storage for "raid 0", 26 seconds.
Search all forums for "test", 43 seconds.
Any idea why this is taking place? Only 100 results are available, so the SQL server shouldn't have to grind through so much stuff regardless of how many results are being returned. I dunno, it just seems counter-intuitive.
I notice that searches are very slow, 30+ seconds in cases where many results will be returned. Examples:
Search main forums for "amd", 60 seconds.
Search Disk Storage for "raid 0", 26 seconds.
Search all forums for "test", 43 seconds.
Any idea why this is taking place? Only 100 results are available, so the SQL server shouldn't have to grind through so much stuff regardless of how many results are being returned. I dunno, it just seems counter-intuitive.