Send Them All Back To 1985

Listens to developer explaining how MySQL is no good for really large databases, like, over 100MB.

Looks at 6TB MySQL production database handling several thousand transactions per second.*

Raises eyebrow.

It's pretty obvious he's got broken joins.  The advantage we had back in the good old days was that rather than taking several seconds to return your data, it would take several weeks, and you could hear the drive heads thrashing about while it happened, so it was kind of obvious that you'd screwed up.

I've seen far too many programs where someone has failed to realise that the half a second or so that a function takes is because they've got it completely wrong, and it should be taking milliseconds or even microseconds.  Send them all back to 1985, I say.  Here's your Unix box.  We just upgraded it: It now has two megabytes of RAM!

* Mind you, it's not easy to get MySQL to scale that big on a single server.  But 100GB is perfectly manageable, and that's a thousand times what this guy was talking about.

Posted by: Pixy Misa at 08:06 PM | Comments (2) | Add Comment | Trackbacks (Suck)
Post contains 186 words, total size 1 kb.