Created On:  04 February 2013

Problem:

In late versions (9.0 though 9.1.2.1) 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.

Resolution:

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 :
 

Export GENESIS_INITSQL=/some_path/my.ini

 

Create the file you pointed at (my-ini) and add the entry "set option mkeyop off" to that file.

N/A