>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"
Because of the bug in VFP9, the indexes with STR() function are ignored by Rushmore if SET ANSI is OFF. A worcaround is either to SET ANSI ON or replace STR() WITH PADL(,10).
--sb--