>>I have a table that is part of a DBC. It has over 1 million records. When I run the following query in the VFP 8.0 command window, the results come back immediately. Running the same query on the same table in VFP 9.0, the query takes around 6 seconds to run. There is an index on the table for "cUoCode + cFtcCentury + cFtcCode + TRANSFORM(lFtdAdversary, "Y") + cFteCode + STR(iFtfEntry) + TTOC(tFtfEntered, 1)". Is there anyway to speed this query up, like it was in VFP 8?
>>
>>SELECT *
>>FROM ft_file
>>WHERE cUoCode + cFtcCentury + cFtcCode + TRANSFORM(lFtdAdversary, "Y") + cFteCode + STR(iFtfEntry) + TTOC(tFtfEntered, 1) = "12005-00001N"
>
>Check if CPCURRENT() and CPDBF() are identical, if not you must change the codepage for the table.
CPDBF() = 1252
CPCURRENT(1) = 1252
CPCURRENT(2) = 437

Does this look OK?