Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Same query in VFP 9 runs slower than VFP 8
Message
From
21/09/2005 10:24:51
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01051638
Message ID:
01051641
Views:
12
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform