I've been using full-text for quite some time, but I switched to another product for quite some time. The reason is that microsoft full-text doesn't offer the feature where one can get a resultset of page x out of y pages, i.e: give me top 100 matches of page 125 out of 5000 pages. I disappointedly waited for SQL Server 2005 and now it doesn't seem to support in sql server 2008 full-text search either. I had to get all 5000 pages of data, then jumped to page 125 to get just 100 records of that page--had to go get a coffee and came back for a 2+ millions rows table. Customers want the result in a split of a second.
Anyone knows if the final version of sql server 2008 will have better support for paging and getting top x rows? I scanned through 2008 BOL and didn't see any change from sql server 2005 or even sql server 2000 full-text search. (one improvement in sql server 2005 over sql server 2000 was the speed of populating large catalog and multiple languages support)
Thanks,
HH
As the final or even the CTP version with these functions is not out, you won′t get a defintite answer to your questions, but there are (even more than) plans to integrate the fulltext engine in the relational engine which will be able to do query optimization on the fulltext part as well. But you never know if it makes into the final version. :-)
Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment