General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL query time in 5.0 vs 6.0
Hi to you all,
We have this table created by sql remote data view. It's an exact copy of the table on an oracle server, 155 fields. Data types are Character, Numeric and DateTime only. Rec count is over 33,600 records.
Using vfp5, the following SQL takes less than half a second, whereas in vfp6 it takes over 15 secs. any ideas why will be greatly appreciated. We're trying to migrate from 5.0 to 6.0
SELECT DIST FY FROM TABLE ORDER BY FY INTO CURS ACURSOR
Alberto
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only