Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

Re^5: Why is MySQL so slow?

by tinita (Parson)
on Jul 21, 2011 at 20:09 UTC ( #915985=note: print w/ replies, xml ) Need Help??

in reply to Re^4: Why is MySQL so slow?
in thread Why is MySQL so slow?

Premature optimisation is the root of all evil!!

why do people always forget to mention the rest of the quote?

"We should forget about small efficiencies, say about 97% of the time: premature optimization is the root of all evil. Yet we should not pass up our opportunities in that critical 3%."

Comment on Re^5: Why is MySQL so slow?
Replies are listed 'Best First'.
Re^6: Why is MySQL so slow?
by davido (Archbishop) on Jul 21, 2011 at 20:14 UTC

    I blame the cargo-culting of catch phrases, and failure to investigate further, which is akin to developing a solution without thorough understanding of the tools being used, or without learning from the successes and failures of alternative approaches.

    How often we take one of two roads: Dismiss a piece of advice for failing to follow it through to its logical completion, or blindly follow an incomplete piece of advice for failing to follow it through to its logical completion.

    Your post is my favorite of the day!


      If only the world's cultures had examined each others methods of writing before they wrote all their books, then we would not have this problem:

    • Hello World
    • Hallo Welt
    • hello κόσμο
    • halo dunia
    • नमस्ते दुनिया
    • مرحبا العالم
    • こんにちは世界
    • שלום בעולם
    • привет мир
Re^6: Why is MySQL so slow? (3%)
by tye (Sage) on Jul 22, 2011 at 06:50 UTC

    Knuth was being generous and trying to not sound like he was exaggerating (I believe). 3% of them are not critical. Much less than 1% of optimizations are critical. Maybe a total of 2% rise above "insignificant". But, "... forget over 99% of ..." just sounds hyperbolic. Or maybe he just hung out with a significantly wiser crowd than I do (and than probably most of us do).

    - tye        

      I believe that it also depends a lot on the nature of the application. In my experience it feels more than 3%. Also "premature" optimization depends on experience. The more applications you've written or maintained and optimized, the more decisions about algorithms and software architecture you can make in advance.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://915985]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (4)
As of 2015-11-29 06:36 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (748 votes), past polls