Sergey,
I did some more testing, and it seems like I may have had some table corruption. I reindexed the table, and the results were as before, meaning slow on VFP9, instant on VFP8. But after I did a series of COPY TO newfile WITH CDX, first to a temp file, and then from the temp file to overwrite the original file, everything is fine..! I am convinced I did the exactly same thing yesterday!!
Thank you anyway for the tips. I will do some more testing later this afternoon/night, I will send you a private email with some sample data if the problem reappears.
>Tore,
>
>Can you create a copy of your table with all the indexes and a few hundred records, zip it up and email to me?
>
>>
>>I have tried all the four different options, Machine, general, nordan and swefin, all with the same result.
>>
>>By the way, simple LOCATE FOR searches give the same results, but I guess that is logiocal.
>>