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 |
|
si_g
Starting Member
4 Posts |
 Posted - 2003-11-25 : 05:38:11
|
| Hi, I hope someone can help with this! We've got a fast growing database and over the weekend some pretty crazy speed problems have started to arise. I think I've narrowed it down to the following:We have some searches that are looking through a view. The major slow downs seem to happen when we are using the 'like %%' clause to get partial string entries. Everything else seems to work ok. There is also a problem with a query that selects distinct and has a few joins in it. It just takes forever or times out.I have been looking into and experimenting with full text searches and they help a bit but it's still slow?!?!We have applied indexing to the database and that helped loads but now it is falling over in the areas I've explained above. I'm thinking maybe we have a corrupt index?Also, could using views as the basis to search data be a bad idea? Have we hit some kind of threshold?Anyway, the system set up is SQL Server 2000 with a VB 6 app front end. Searches are looking through up to 17,000 records at any one time. One central database with about 100 concurrent conections over 3 sites. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2003-11-25 : 06:11:52
|
| You'll have to post the queries being executed, and sample table structures (DDL) to get closer to a solution....your problem as described is too vague for any meaningful advice to be given.We also need to see your "execution plan"s from QA.17000 records is not a lot for SQL to manage....some of the people here are dealing with GB's of data. |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-11-25 : 09:02:49
|
| If you are running searches that start with the % sign it will limit or remove the use of indexes for that query. You should find that results are returned faster if you put at least one character in front of the % sign.-------Moo. :) |
|
|
|
xpandre
Posting Yak Master
212 Posts |
Posted - 2003-11-27 : 01:54:07
|
| using column like '%x' results in a full table scandistinct clause causes full table scan too! |
|
|
|
|
|
|
Severe Speed Issues!! Help!