Unfortunately when I run

?CPCURRENT()
?CPDBF()

I get the same answer - 1252

I have never changed the codepage and have always used the default.
VFP8 returns full optomisation

VFP9 returns partial optomisation

Regards
Geoff


>Yes. See Message #972627.
>
>>
>>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.
>>>>