Alfredo,    Why not give us the choice when we run Adager?
 
Lee Gunter          [log in to unmask]
 
 
______________________________ Reply Separator _________________________________
Subject: Prefetch
Author:  "F. Alfredo Rego" <[log in to unmask]> at ~INTERNET
Date:    9/15/96 8:32 PM
 
 
Point your web browser to
 
        http://www.robelle.com/newsletter/w1996-02.html
 
and you will see that Robelle kindly published the following in "What's Up,
DOCumentation?", 1996 # 2:
 
--------------------
 
Technical Tips
 
Polish Your IMAGE
 
... 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.
 
--------------------
 
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.
 
        - 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 :-)
 
Thank you,
 
 
 
 
+---------------+
|               |
|            r  |  Alfredo                     [log in to unmask]
|          e    |                           http://www.adager.com
|        g      |  F. Alfredo Rego               Tel 208 726-9100
|      a        |  Manager, Theoretical Group    Fax 208 726-2822
|    d          |  Adager Corporation
|  A            |  Sun Valley, Idaho 83353-3000            U.S.A.
|               |
+---------------+