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 - 2002-07-19 : 08:28:21
|
| Vivek Jain writes "I have a table containing 1.2 million records. I had full text indexed the column which I need to search. When I fire a query using CONTAINSTABLE predicate it give me too many rows. I only need to display the 10 rows to front-end. So I limit the rows retured by using top_n_by_rank parameter to 10. But at the same time I want to know how many records were found so that I can show this on front-end(to show the paging bar like google).Or is there any other way to implement this functionaliy with faster performance.Thanks RegardsVJ" |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-19 : 14:28:52
|
| I would still be tempted to limit the number of rows passed back from Full Text Search - it is the number one thing you can do to improve FTS performance. Paging results is the same whether its full text or not - there are quite a few ways to do it. On our sites we use a temp table and the asp passes in a page number. Search google for paging results in the SQL groups and you'll get plenty of examples. There's a probably a few in these forums and on the site as well.HTHJasper Smith |
 |
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-07-20 : 08:04:08
|
| Try XML features of SQL Server 2000.....---------------------------Sandesh - The Messanger |
|
|
|
|
|
|
Full Text Search Query