F. Alfredo Rego writes:
 
>>... it was recommended that all IMAGE/SQL databases should have prefetch
>>enabled by using Dbutil. This option can increase performance by up to 35%.
>>One older version of
>>IMAGE/SQL on MPE/iX 4.0 has a bug in this feature, but unfortunately we
>>don't have any notes on the specifics. We can, however, recommend it to all
>>MPE/iX 5.0 users.
 
We are on the following version(s) of Image/SQL and have had no problems
using prefetch:
 
VERSION
 
    QUERY     D.03.03
 
TurboIMAGE Overall VUF:
    HP30391C.04.19  TurboIMAGE/XL
TurboIMAGE Procedures:
    DBOPEN     C.04.19
    DBINFO     C.04.19
    DBCLOSE    C.04.15
    DBFIND     C.04.19
    DBGET      C.04.16
    DBUPDATE   C.04.17
    DBPUT      C.04.15
    DBDELETE   C.04.15
    DBLOCK     C.04.19
    DBUNLOCK   C.04.19
    BIMAGE     C.04.19
    DBCONTROL  C.04.12
    DBBEGIN    C.04.06
    DBMEMO     C.04.06
    DBEND      C.04.06
TurboIMAGE Program Files:
    DBSCHEMA.PUB.SYS   C.04.09
    DBSTORE.PUB.SYS    C.04.00
    DBRESTOR.PUB.SYS   C.03.02
    DBUNLOAD.PUB.SYS   Not available.
    DBLOAD.PUB.SYS     Not available.
    DBUTIL.PUB.SYS     C.04.14
    DBDUMP.PUB.SYS     C.02.00
    DBRECOV.PUB.SYS    Not available.
TurboIMAGE Reference Manual:
    Edition 4  June 1992     30391C.04.00
Third-party Indexing Product:
    SUPERDEX (18085e)    Version: 4.0.A7
 
>Our own Adager investigations have not yielded more than 5% to 10%
>improvement.  And we could not get more concrete details from Robelle
>regarding the 35%.
 
>Nevertheless, assuming that a 5% to 10% is better than nothing, I have
>added the necessary logic to Adager to automatically enable prefetch for
>all Adager-transformed databases IF you are on MPE/iX 5.0 or later.
>(Naturally, as you would expect from Adager, I tell you that I have done so
>and WHY I have done so.)
 
>Before I release this automagic feature to the world, I would like to
>conduct a survey among this elite group of HP3000 users.
 
Gee, I thought the elite always meet on Basin Street!
 
>        - Would you like for Adager to automatically ENABLE
>         prefetch for all Adager-transformed databases?
 
>        - Would you NOT?  (If so, why not?)
 
>I believe we should follow the recommendation reported by Robelle.  But
>more conservative people might feel uneasy about it.  Since I am more
>aggressive than conservative, I am asking for your feedback :-)
 
To answer your questions, Alfredo, I would like Adager (yes, I am a customer)
to ENABLE prefetch for all of my data bases.
 
Jim Phillips
[log in to unmask]