[rt-users] Re: [rt-devel] DBIx-SearchBuilder 0.81 released

[Jeroen Ruigrok/asmodai]

-On [20030505 10:32], Paul Wagland (pwagland at allshare.nl) wrote:
>Well, I was one of the people that noticed a massive improvment in execution
>speed... Sadly it that gain appears to of have been all environment.

Any DBA worth his or her salt will tell you that 80% of all performance
issues with databases come from badly created queries.  And with some
careful examining and rewriting you will gain huge speed-ups.
Then you get OS tuning and hardware...

And I've seen this too often in real environments to discard their
wisdom on this matter.

Do note that I am not saying that getting better hardware will not be a
solution, but it is the wrong solution in the most cases.

-- 
Jeroen Ruigrok van der Werven <asmodai(at)wxs.nl> / asmodai / a capoeirista
PGP fingerprint: 2D92 980E 45FE 2C28 9DB7  9D88 97E6 839B 2EAC 625B
http://www.tendra.org/   | http://www.in-nomine.org/~asmodai/diary/
Only the wisest and the stupidest of men never change...