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]>
>