In late versions (9.0 though 22.214.171.124) querying a set of files you noticed a hit performance, either using asql or from a desktop software like Excel or Crystal Reports, compared with 8.1.2 or previous the performance decreased dramatically.
This is due to an enhancement introduced in version 9.0.0 that can be avoid by doing the following:
If the query is executed from asql:
Go int asql and type this command:
SQL (/? for help) ==> set option mkeyop off;
and then run your query again,
If the query is executed from a desktop software
Right click on the "Computer" icon and select properties.
Click "Advanced system settings"
Click "Environment Variables..."
User "System variables" (just to be safe) click "New"
Add a variable "GENESIS_INITSQL" and set it to point to a file like "C:\xtst\bin\my.ini"
and click "ok"
Create the file you pointed at and add the entry set option mkeyop off to that file.
save the file.
If this is on UNIX/Linux
You can do the same by setting the following environment variable :
Create the file you pointed at (my-ini) and add the entry "set option mkeyop off" to that file.