D
dbeavon
Guest
Can someone tell me the way to flush my database buffer pools on a Progress database? Some parts of our code run consistently in 5 seconds during certain times of the day when the database is relatively unused; but later on during a busier time of day we will notice that the same code runs in 15 seconds whenever it is executed. Some basic troubleshooting shows that the performance problem is *not* CPU utilization (or at least only 5 seconds of it is CPU, and the rest is probably related to buffers needing to be reloaded from disk.) After flushing buffers, I should be able to run performance tests and try to isolate disk as the performance bottleneck that adds the extra 10 seconds in a consistent way. I found this in the KB: http://knowledgebase.progress.com/articles/Article/How-to-clear-out-database-cache-from-memory-buffers-for-query-testing However, I still suspect there is a secret ABL program or promon command to clear the database buffers. With all that Progress gives us to monitor our buffers, track hit ratios, and create alternate buffer pools, I find it extremely unlikely that they don't have a way to flush clean buffers from memory. Could there be something in promon/rnd/debghb that I overlooked?
Continue reading...
Continue reading...