would you need a Astrix both sizes of 'eagle'?
freetext(companyName, '"*eagle*"')
On 7/6/07, Brett Payne-Rhodes <[EMAIL PROTECTED]> wrote:
>
>
> Sure...
>
> select companyName, companyState from companyDetails
> where freetext(companyName, '"eagle*"') and companyState = 'WA'
> order by companyName
>
> Returns 121 rows in 2 seconds
>
> While...
>
> select companyName, companyState from companyDetails
> where companyNamelike '%eagle%' and companyState = 'WA'
> order by companyName
>
> Return 149 rows in 25 seconds
>
>
> So the performance increase is there, but the results aren't what I was
> expecting.
>
> My impression is that the full-text search looks for the word 'eagle' and
> a few variations like 'eagles' but does not pick up versions such as
> 'eaglehawk'.
>
>
> Thanks,
>
> Brett
> B)
>
>
> Taco Fleur wrote:
> > Can you post your SQL?
> >
> > On 7/6/07, *Brett Payne-Rhodes* <[EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>> wrote:
> >
> >
> > I'm trying to speed up a wildcard search on a text field along the
> > lines of SELECT companyName from companyDetails where companyName
> > like '%eagle%'
> >
> > The database is mssql 2005 and the table has over two million rows.
> >
> > What I have already done is to create a full-text index on
> > companyName and while it does appear to run faster, the results
> > generated by the query using the full-text index aren't even nearly
> > the same as the results of the wildcard query in that the wildcard
> > search picks up 'eaglehawk' but the full-text query doesn't, even
> > using "eagle*".
> >
> > Can anyone explain this for me or point me to a reference that will
> > help?
> >
> > Thanks and sorry for the OT but I thought other people here might be
> > interested.
> >
> > Brett
> > B)
> >
> >
> > http://www.clickfind.com.au
> > The new Australian search engine for businesses, products and
> services
> > >
>
>
> >
>
--
If you are not living on the edge,
You are taking up too much space.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---
