Click here to Skip to main content
15,890,741 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: have you ever been stuck on a programming problem Pin
Espen Harlinn5-Oct-15 14:41
professionalEspen Harlinn5-Oct-15 14:41 
GeneralRe: have you ever been stuck on a programming problem Pin
Dan Sutton6-Oct-15 8:03
Dan Sutton6-Oct-15 8:03 
GeneralRe: have you ever been stuck on a programming problem Pin
Amarnath S5-Oct-15 17:33
professionalAmarnath S5-Oct-15 17:33 
GeneralRe: have you ever been stuck on a programming problem Pin
dan!sh 5-Oct-15 18:04
professional dan!sh 5-Oct-15 18:04 
GeneralRe: have you ever been stuck on a programming problem Pin
GuyThiebaut5-Oct-15 21:17
professionalGuyThiebaut5-Oct-15 21:17 
GeneralRe: have you ever been stuck on a programming problem Pin
Jörgen Andersson5-Oct-15 22:53
professionalJörgen Andersson5-Oct-15 22:53 
GeneralRe: have you ever been stuck on a programming problem Pin
Slacker0075-Oct-15 23:16
professionalSlacker0075-Oct-15 23:16 
GeneralRe: have you ever been stuck on a programming problem Pin
David Days6-Oct-15 2:43
professionalDavid Days6-Oct-15 2:43 
Had problem like that--"legacy" web app written in some third party take on ASP.NET and JSP. It was "legacy" in that the code was written before we took over a contract by another contractor (so no going back to them without major $$), but it was only a year old.

Now that we were responsible, the users were asking that we fix the weird issue of extremely poor performance and daily lockups of the entire system.

I was given the task of figuring out how the code worked so I could go through and fix it. When I finally get the source code installed and 3rd party IDE up..."Hmmm...almost zero logic in the code as far as I can tell...these are strange calls..."

I go look in the database, and voila! All stored procedures. I tell myself, "Okay, I can work with this!", and start scrolling through a stored procedure...

...and scrolling...

...and scrolling...

...and scrolling...

Oh My Elephanting God! One stored procedure (the one that was suspected in causing the lockup) was 12,000 lines! And there were 30 more! Tried printing it out to do a manual refactoring--it was 250 pages of stored procedure SQL, and there was no consistency in anything.

My final report back was this:

1. This is a horrible app.
2. If you want it "fixed", I need 6 weeks and the option to just rewrite the whole thing in a more stable and common language (.NET, JSP, assembler, whatever...I didn't care--anything would be better than this nightmarish blend of old ASP and Black Speech).
3. If you want it to run "better", move it to a big iron database (we had several) and don't look at it until you want to rewrite it.

They went with option #3. Every 6-8 months, I would be told to take another look, and occasionally I would be able to make a small modification that wouldn't crash the whole system.

I left a few years later, and as far as I know, it's still out there, a monument to both Horrible Implementation and "The problem I couldn't crack".
vuolsi così colà dove si puote
ciò che si vuole, e più non dimandare
--The answer to Minos and any question of "Why are we doing it this way?"

GeneralRe: have you ever been stuck on a programming problem Pin
GuyThiebaut6-Oct-15 4:33
professionalGuyThiebaut6-Oct-15 4:33 
GeneralRe: have you ever been stuck on a programming problem Pin
sir_download_alot5-Oct-15 22:17
professionalsir_download_alot5-Oct-15 22:17 
GeneralRe: have you ever been stuck on a programming problem Pin
Brad Stiles6-Oct-15 2:25
Brad Stiles6-Oct-15 2:25 
GeneralRe: have you ever been stuck on a programming problem Pin
Dan Sutton6-Oct-15 8:02
Dan Sutton6-Oct-15 8:02 
GeneralRe: have you ever been stuck on a programming problem Pin
Member 110348066-Oct-15 2:39
Member 110348066-Oct-15 2:39 
GeneralRe: have you ever been stuck on a programming problem Pin
Kirk 103898216-Oct-15 3:04
Kirk 103898216-Oct-15 3:04 
GeneralRe: have you ever been stuck on a programming problem Pin
patbob6-Oct-15 5:18
patbob6-Oct-15 5:18 
GeneralRe: have you ever been stuck on a programming problem Pin
fglenn6-Oct-15 6:54
fglenn6-Oct-15 6:54 
GeneralRe: have you ever been stuck on a programming problem Pin
Ygnaiih6-Oct-15 7:08
professionalYgnaiih6-Oct-15 7:08 
GeneralRe: have you ever been stuck on a programming problem Pin
Dan Sutton6-Oct-15 8:01
Dan Sutton6-Oct-15 8:01 
GeneralRe: have you ever been stuck on a programming problem Pin
Bruce Patin6-Oct-15 10:34
Bruce Patin6-Oct-15 10:34 
GeneralRe: have you ever been stuck on a programming problem Pin
obermd6-Oct-15 16:07
obermd6-Oct-15 16:07 
GeneralRe: have you ever been stuck on a programming problem Pin
R. Erasmus6-Oct-15 21:07
R. Erasmus6-Oct-15 21:07 
GeneralThought of the Weak Pin
MacSpudster5-Oct-15 8:00
professionalMacSpudster5-Oct-15 8:00 
GeneralNo, that's not what current means Pin
loctrice5-Oct-15 6:14
professionalloctrice5-Oct-15 6:14 
GeneralRe: No, that's not what current means Pin
Ian Shlasko5-Oct-15 6:21
Ian Shlasko5-Oct-15 6:21 
GeneralRe: No, that's not what current means Pin
PIEBALDconsult5-Oct-15 10:19
mvePIEBALDconsult5-Oct-15 10:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.