System Optimization

[Darren Reely]

It has been 10 years, so my memory is a little vague. One important 
lesson I learned was to reference your indexes. Don't rely on the 
compiler doing the right thing.

I once was trying to figure out why a report was taking 2.5 hrs to run. 
When I looked at the code it was obvious. The coder of the Quiz program 
did not specify which indexes to use. I added index specifiers with the 
'VIAINDEX' structure and the report ran in under 15 minutes.

I used to also have the systems guy optimize my tables every once in a 
while. This helped the above mentioned report a few times until I could 
take a look at the code. It saved maybe 20% of the run time. I really 
don't remember any details of what they did.

Darren

Desmond Dujon wrote:
> Hi folks.Happy new year.
>
> Are there any commands /parameter changes ( apart from
> autogen) you can suggest to speed up performance on
> our ES47 Alpha server running OpenVMS 7.3 , Powerhouse
> 7.10.g3. Some of our quiz reports involve alot of
> calculationa , take hours to run and are very cpu
> intensive. Most of the files accessed (RMS files) are 
>  700,000 blocks and less. No database is used. 
>