Is this always a brute-force search?

Jerry

Jerry


If its indexed and you use TEXTSEARCH it shouldn't be. AT least it isn't for me.

Roy Lambert

Jerry,

<< Is this always a brute-force search? >>

If the memo field is full-text indexed, then it is never a brute-force
search if you're using the TEXTSEARCH() function.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks, guys. Well, that's what I'm doing but the searches seem to take a
long time. I'll have a look at the code again.

Jerry

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:39804D16-1CB9-43E9-87C1-5C5680A94455@news.elevatesoft.com...
| Jerry,
|
| << Is this always a brute-force search? >>
|
| If the memo field is full-text indexed, then it is never a brute-force
| search if you're using the TEXTSEARCH() function.
|
| --
| Tim Young
| Elevate Software
| www.elevatesoft.com
|
|

Jerry


If its a query try it in DBSys and look at the plan to see where its unoptimised. If its a filter pretend its a query

Roy Lambert

Roy,

Thanks. Actually, I'm using the TEXTSEARCH() function and the problem may
have cleared up. I'll remember to try this. DBiDesktop is another
alternative I have and it is doing virtually instant searches.

Jerry

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:7CE97AEA-2FA3-4E32-845D-3EE9E442CC31@news.elevatesoft.com...
| Jerry
|
|
| If its a query try it in DBSys and look at the plan to see where its
unoptimised. If its a filter pretend its a query
|
| Roy Lambert
|