Ding! Ding!
Ringside announcer 1: In the red corner, we have a braaaaaaand new Sun E6900 running Oracle 10g.
Aaaand in the blue corner, we have a single stored procedure written by the Master of Coding Disaster Waaaade Olson; pulling 66 fields from no less than 15 full-outer joined tables, each table having upwards of 4 million rows and joining on non-indexed columns, all fully sorted. *
Ringside announcer 2: This could be a fast fight....it's going to be a bloodbath!
Toady teammate: Get a bodybag man!
Bookie: Place your bets!
* Unbelievably dba-tuned and approved. Go figure. I'm washing my hands of this debacle. Based on client requirements, there is *no* other way to code this monstrous Kraken.
Aaaand in the blue corner, we have a single stored procedure written by the Master of Coding Disaster Waaaade Olson; pulling 66 fields from no less than 15 full-outer joined tables, each table having upwards of 4 million rows and joining on non-indexed columns, all fully sorted. *
Ringside announcer 2: This could be a fast fight....it's going to be a bloodbath!
Toady teammate: Get a bodybag man!
Bookie: Place your bets!
* Unbelievably dba-tuned and approved. Go figure. I'm washing my hands of this debacle. Based on client requirements, there is *no* other way to code this monstrous Kraken.
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home