Hey Sergey
Did this get resolved? I have just discovered that all my views are taking about twice as long as in VFP7.
Regards
Geoff Scott
>Tore,
>
>I still think it has something to do with SET COLLATE but I could be mistaken.
>
>>
>>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.
>>
May all your weeds be wildflowers