Re: FTS query performance on SQL 2005

Thanks for the reply. Yes, this is SQL 2005 - what optimizations are you
referring to? I believe I have applied all optimizations that I've been able
to find in the various posts and online docs.

I know that I can limit the size of the resultset with top_n_by_rank, but in
this case, I'm trying to get back the full set of results. Another form of
my query is to do a "select count(*)", which has the same response times. I
believe this is because the full resultset is returned from the FTE back to
SQL Server, and then the count is taken on that. Is there a way to structure
the query to tell the FTE that you just want the count of results, so that
it doesn't ship the full results back to SQL Server?

Essentially, I'm trying to create a search engine, where the results will be
displayed back to the user in paginated form, so it will always display a
subset of the resultset, but I'd like to also display "Showing results 1-20
of 40,000", so I need a way to get the size of the resultset.

With regard to hardware, would you expect that I will get the most bang for
my buck by a) spreading my data across more disks (via RAID) in a single
server, b) creating a cluster of separate servers, c) adding more memory, or
d) adding more CPU's?

Thanks.



.

Relevant Pages

  • Re: FTS query performance on SQL 2005
    ... I believe I have applied all optimizations that I've been able ... believe this is because the full resultset is returned from the FTE back to ... SQL Server, and then the count is taken on that. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Stored procedure that returns an empty resultset as well as a resultset when it shouldnt
    ... based on ItemID and ModuleID. ... entered and a resultset generated, I have an empty resultset at the ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.programming)
  • Way to select certain columns from stored procedure
    ... I'm using SQL Server 2000. ... I have a stored procedure that returns a resultset. ...
    (microsoft.public.sqlserver.programming)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: WSS 3.0 question
    ... I followed the advise given in removing WSS 3.0 etc, ... the server is complaining that the SQL service(?) was tempered with or corrupt. ... I may just instal the SQL server as I was going eventuall use it anyway. ... If WSUS 3.0 is installed, I would suggest you uninstall it and then you install WSS 3.0. ...
    (microsoft.public.windows.server.sbs)