yesterday’s activity – get the slow query to go faster. Two things
1. $ ASSIGN 4000 RDM$BIND_BUFFERS
changed the size of the database window from 200 buffers by a factor of 20. This allowed very large portions of the thrashing index area to reside in memory (60 I/O per second down to 1)
2. $ SET VOLUME DISK$SCRATCH /EXTENSION=16000
changed the file extend size from 5 – huge increase. Went from 3 extends per second to .03
Result? Approximately 12 hour query down to about 1 hour with zero code changes!
I like that!