mrdenny
Programmer
- May 27, 2002
- 11,595
We have a table that has full text searching on it. It works fine, except that when performing a full text search on the table, it takes several minutes to return a result.
The table has 12 million records in it. The current full text catalog is for the PK, a varchar field, and the text field.
Our engineer is asking if there is a way to have several catalogues for one table, where each catalogue is only for a subset of the data.
I'm pretty sure that a table can only have one catalogue, but I figured that it wouldn't hurt to ask.
Does anyone have any other ideas on how to speed the searches up? Would a dedicated array for the full text catalogues help?
Any other ideas would be great.
Denny
Between the ESP=ON and the RUM (Read Users Mind) upgrade, I'm ready to go.
The table has 12 million records in it. The current full text catalog is for the PK, a varchar field, and the text field.
Our engineer is asking if there is a way to have several catalogues for one table, where each catalogue is only for a subset of the data.
I'm pretty sure that a table can only have one catalogue, but I figured that it wouldn't hurt to ask.
Does anyone have any other ideas on how to speed the searches up? Would a dedicated array for the full text catalogues help?
Any other ideas would be great.
Denny
Between the ESP=ON and the RUM (Read Users Mind) upgrade, I'm ready to go.