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. | | +---------------+