>Working with VFP 3.0
>I am getting data from text files into memo field with APPEND MEMO memofield FROM textfile OVERWRITE. The text file contains multiple data in no particular order (no columns,no CR/LF). I am using AT(searchstring,memo field,i) function in sequence (for i = 1 to N and AT()<>0)to locate the desired segment which contains usefull data for me. The size of txt files does not exceeds 48 K.
>It worked fine until now. Now I have files up to 200 K and this procedure is working to slow. Does the speed of AT() depends on txt file size stored in memo field? If it is , is there any faster solution?
Angel,
Another thing to think about on this is packing the memo files. I found some time ago that append memo increases the size of the memo file and I had to keep packing the memo file to keep the speed up!