Re: reduce time for search query

On Tue, 26 Feb 2008 04:41:24 -0800 (PST), paankhate@xxxxxxxxxxxxxx
wrote:

Hi,

I have a task at hand to reduce the time taken for search query to
execute. The query fetches records which will have to sorted by
degrees away from the logged in user. I have a function which
calculates the degrees, but using this in the search query slows the
execution and takes about 10 secs to complete which is unacceptable.

Please advice. Your help is much appreciated

For more details plz see:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=97021

Hi Isfaar,

I see lots of useful (and some less useful) idea posted to that topic
over at sqlteam.com. Did you already try them? Did they help?

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
.

Relevant Pages

  • Re: AIX Oracle SSA performance issues.
    ... > I have noticed immense performance issues with server in peak hrs, ... > per my observation before we / user execute any search query on ... > database system performs in reasonable condition ASA we execute any ... > Server performance before user execute any query on database. ...
    (comp.unix.aix)
  • Re: Frame Set Flow
    ... simplest method .. ... build the search query string and assign to ... in "WebForm2.aspx" execute the search query in session and display ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Need help with full-text performance for large database
    ... Yukon or now officially known as SQL Server 2005 Full Text Search will ... on the FT Search query side, between 30 & 50% improvement in query times ... > indexing in the Yukon SQL server that is being field tested? ...
    (microsoft.public.sqlserver.fulltext)