Re: search in memo field

Hi Bijan:

Along with Dan's suggestions, don't forget to optimize memory using the
SYS(3050) function. See

176483 Computers that have lots of RAM installed seem to more slowly
process data in Visual FoxPro
http://support.microsoft.com/default.aspx?scid=kb;EN-US;176483

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

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