home links tools blog about

« Something New Everyday | Main | The idiot RIAA »

March 29, 2004


Jon Sharp

Do you have it output to a database, or a text file? Wouldn't that get huge pretty fast?

Michael K. Campbell

Actually, the routine will just sit there in a loop until it sees a block. If no blocks occur, it just keeps looping and outputs nothing (this will 'burn up' a bit of CPU (as per my warnings/caveats). If it detects a block, it fires off a few statements that grab the last queries by the blocking/blocked PIDs, outputs them, and then it's done. I'll probably work on making a bit of a cleaner build in the future, so that it won't be dependant upon the formatting provided by QA in Text Output mode.

The comments to this entry are closed.