Categories
Rdb

Speeding up Queries

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!