in reply to OT: Scalable web application architecture

It sounds like you either need a substantial rethink of how your application works and does its work or you need some database optimization foo.

The former is hard to guess at without more information on the system, but the latter is easy enough to take a few shot at.

You might find the slides from my ApacheCon/MySQL UC/OSCON talk useful.

- ask (available for short contracts working on that sort of problems)