John
Express-3 makes a dramatic improvement in the usability of IMAGE/SQL. Prior
releases did not register the keys with the Allbase Optimizer so serial
reads were always performed. I get < 5 sec responses on datasets much larger
then yours.
Gary L. Biggs
At 10:12 AM 3/4/96 -0500, you wrote:
>Greetings:
>
>I have executed the following query in isql and MS Access. The field
>QSQMS.QC_CURR_DTL.QC_TU_KEY is the primary path to the dataset.
> OBSERV_ID is not a key. It appears that Image/SQL performed a serial
>read on the dataset to obtain the results of this select. I think
>Image/SQL should have used the path to retrieve these 5 records, but it
>did not. This select takes approximately 65 seconds to execute on a
>dataset with ~175k entries. Any opinions out there? ....
>
>Is there anyone who has installed the Express 3 patch? If so, did it
>improve your access to Image keys? Would Express 3 have resulted in
>Image/SQL utilizing the path for the above query?
>
>John Spivey
>Sumitomo Electric
><[log in to unmask]>
>