mainegreen
(1000+ posts)
Send PM |
Profile |
Ignore
|
Wed Nov-14-07 12:20 PM
Original message |
|
Stop running 40 reports at a time!! Patience people! If you are trying to pull up a financial report that chops up the last decades data seven ways to Sunday it's going to take more than two seconds. Don't run it three more times! You're killing my database server people!
Don't make me come down there and beat you! I *WILL* revoke your privileges and place you in the naughty corner!
:mad:
Why has god cursed me with end users?
|
DS1
(1000+ posts)
Send PM |
Profile |
Ignore
|
Wed Nov-14-07 12:32 PM
Response to Original message |
1. "whaddayemean I can't have a full table scan dumped to php |
|
which generates a 600 page in html report whenever I want?"
yep, been there.
|
mainegreen
(1000+ posts)
Send PM |
Profile |
Ignore
|
Wed Nov-14-07 12:43 PM
Response to Reply #1 |
2. Today one of them created the most evil deadlock I've ever seen in my life. |
|
It spanned about seven tables. It was awe-inspiring. Truly, I had no idea one user could click so many links so furiously as to create such a beast. In the end, that deadlock caused my linux server to bounce on its own.
Amazing.
|
DU
AdBot (1000+ posts) |
Sun May 05th 2024, 08:06 AM
Response to Original message |