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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-22 : 22:07:58
|
Carl writes "Hi Mr Guru,
I'm at my wits end now! I've got what I though would be a simple full text index for SQL Server 7 to deal with, but it's having extreme problems. I have a table, with a full text index built on a varchar (500) and varchar (70) column, there are around 90000 rows and to cut a long story short I'm querying the table with a CONTAINSTABLE however, if the server has to return anything more than around 1000 records it can take anything up to 2 minutes to do it! All I really need to know is whether this is normal or not - MS have a solution whereby you can call back the top n records, but this isn't appropriate for me since I need to count the records returned.
At this stage I could do with knowing whether I should invest in a bolt on indexer since I have an extra 400,000 records to add and if it can't cope with 90000 I dread to think what it will do with half a million! Any ideas much appreciated.
All the best." |
|
|
|
|
|
Super slow Full Text Search