Re: Challenging performance demand

[Nathan Cheng]

This probably isn't the right place to suggest such heresy, but if you've only got 100k rows x 50 bytes per row + you don't care about data integrity and keeping the data overnight + you've got a whole machine to spare for this + the queries are relatively trivial + speed is the most important thing ==> with a relatively simple, custom-written C/C++ program you could probably pretty easily achieve millions--perhaps tens of millions--of hits per second. Even something written in Java could probably get into the millions. Sorry to say, but a full-fledged RDBMS isn't always the best solution, even if you're talking about MySQL.