FTS capabilities + questions
Hello,
I have some questions about Full Text Search and how to handle a
scenario that I have. The database that I am going to hit up against
has 80 tables and over 250 fields that will be searched for FTS. This
database has 600 + tables in it so 80 is needed to make the search
meaningfull for the user.
What is the best method to use FTS against so many tables?
Could I build a massive query that dumps the results into a single
table for searching?
Can I use the 80 tables and use some kind of dynamic query to do my
joins so that it scales?
I know this problem isnt unique to our company but just wondering how
some of the gurus have solved this problem?
Thanks in advance.
.
Relevant Pages
- Full Text Search question
... The database that I am going to hit up against ... What is the best method to use FTS against so many tables? ... Could I build a massive query that dumps the results into a single ... I know this problem isnt unique to our company but just wondering how ...
(comp.databases.sybase) - Re: FTS capabilities + questions
... That really depends on the queries you have. ... Director of Text Mining and Database Strategy ... Looking for a FAQ on Indexing Services/SQL FTS ... I know this problem isnt unique to our company but just wondering how ...
(microsoft.public.sqlserver.fulltext) - Re: need to implement full text search
... These are some of the advantages of SQLite's full text search (FTS) over your ... You can OR terms (apples OR pears), exclude terms, perform ... The free DISQLite3 Personal edition contains the SQLite3 database engine as well ... object_id from mytable where keyword like '%akeyword%' ...
(borland.public.delphi.thirdpartytools.general) - Combining FTS and Index Server
... indexing, so I'm not sure exactly what I'm looking for. ... I'm familiar w/ FTS, as I have used this for a message board on another ... both files and database content at the same time. ... and PDF files for storing in the database? ...
(microsoft.public.sqlserver.fulltext) - Re: Misterious disabling of table FTS
... Just to add this was on SQL 2005 sp1 ... Today two tables in the same database (which are the only ones with FTS ... of them were enabled and working and nothing is showing in the logs about ...
(microsoft.public.sqlserver.fulltext) |
|
