home links tools blog about
home

« Something New Everyday | Main | The idiot RIAA »

March 29, 2004

Comments

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.

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment

Comments are moderated, and will not appear until the author has approved them.