>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.