 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / February 2007How to get record count only from FTS
Hi, Is there a way to get the FTS system to return you the count of matches only, without passing back all the key ids. Basically if a user doesn't find what they are looking for with their initial multi term search, i.e '10k resistor tomatoes'. I want to display a list of the counts for each word. 10k = 500, resistor = 46000, tomatoes = 5. This will help them refine their search. select count(*) from freetexttable([MyCatName],*,'resistor') seems quite slow where there are a large number of matches as I assume it's passing the data back for SQL to count. Is there a way to just get the count it came up with. Thanks, No, there is no way to do this using SQL FTS, some of the Microsoft Search engines return a hitcount value which is the raw number of hits for all search tokens. You could maintain a count should you shred all documents in an inverted file index - this will require a lot of work however.  SignatureHilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > Hi, > [quoted text clipped - 14 lines] > > Thanks, Hello Martin, Is this SQL 2000 or SQL 2005. The latter is orders of magintude better at this. We cache keyword counts to achieve something similar Simon Sabin SQL Server MVP http://sqlblogcasts.com/blogs/simons > Hi, > [quoted text clipped - 14 lines] > > Thanks, Hi, it's 2005. It's not a major issue, current method of counting the results is actually performing ok. Shredding inverted file indexes sounds interesting. Any pointers of where to look for info on what you were suggesting..? I assume you > Hello Martin, > > Is this SQL 2000 or SQL 2005. The latter is orders of magintude better at > this. > > We cache keyword counts to achieve something similar |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.