D
dbeavon
Guest
Thanks again for the tip on using "proutil -C dbanalys". It is definitely helping to isolate a disk bottleneck. I run the following (*) for about 5 mins (after picking the right area first). I'm sure this 5 mins only works for me based on the throughput of my disk and the size of the database buffers (-B) : * proutil mydatabase -C dbanalys area myarea > out.txt The *first* time I execute my ABL code after doing this, the behavior of the code is totally different than *subsequent* executions. The most obvious difference is that CPU runs at only 50% on the *first* execution and the code takes 10 seconds longer. On subsequent executions the CPU runs at the full 100%. I still wish Progress would just tell us what the secret command is to empty the clean buffers without having to wait for a full five minutes to pull unnecessary data off of the disk. (There's no way there isn't a secret command for this.) Thanks again, David
Continue reading...
Continue reading...