Re:"I've isolated the bug to a database query"
by einhverfr on Thursday November 10, 2011 @03:04AM
(#3219372)
I'd agree. I'd also add that well written stored procs are often more readable than well written ad hoc queries.
The longest query I have ever written I thought was approaching unmaintainability at about 100 lines, but I can sit down and digest it without too much effort. I have however spent a week debugging a query that was three times that long. I think the time to understand starts increasing with the square of query length...... 100 lines may not take too long to understand, but 200 lines takes 4 times as long, 1000 lines takes 100 times as long, etc.....
At least my experience is that even well written SQL starts becoming a bear really fast when over 100 lines ling.
At least that's my experience.