On Feb 27, 3:22 am, Hugo Kornelis
<h...@perFact.REMOVETHIS.info.INVALID> wrote:
> On Tue, 26 Feb 2008 04:41:24 -0800 (PST), paankh...@googlemail.com
> 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

Yes we have tried most of them, however, we did not get the required
results.

We are at present trying out to have a separate table to store all
relationships between the members, then query this table to get
results.

Will update our findings.

--