Subject Re: [Firebird-Architect] Re: web scale databases
Author Alexander Peshkoff
> Hm, maybe I really should do some benchmark. I have one website with 5k+
> daily visitors, 400k+ PHP page hits and some 5milion-record tables in
> the database - which are read at least twice on each page load.
> Currently MySQL load peaks at about 60-70 simultaneous connections and
> it's handling it well. All this on VPS hosting with 512MB of RAM. Maybe
> I should try rewriting the backend to use Firebird and let it run to see
> where we're at. I guess SuperServer should be able to handle this load
> nicely.

Milan, server kind choice hihgly depends upon number of CPUs available. If >1,
2.5 superclassic (with default cache size) wiil sooner of all be better
choice compared with super even with this small amount of RAM, provided you
do not have very big and complex metadata.