Re: search in memo field

Substring searches like this are going to be notoriously slow. You need an
index that matches your expression.

INDEX ON AT("book",mm) TO TEMP
SELECT * ......

Dan

bijan wrote:
Hi
I have a table with 6 million record .(name of table is ddd)
And I have a memo field in this table (name of memo is mm)

I want search a word in memo field for example search 'book' in memo
field. I wrote this code .

SELECT * from ddd where AT( 'book',mm) >0 into cursor test
Or
SELECT * from ddd where 'book ' $ mm into cursor test

But speed is very low
Is there a butter code for high speed result
Thank you
bijan


.

Loading