Subject | Re: [Firebird-Architect] Re: web scale databases |
---|---|
Author | Alexander Peshkoff |
Post date | 2010-05-28T13:09:09Z |
> Hm, maybe I really should do some benchmark. I have one website with 5k+Milan, server kind choice hihgly depends upon number of CPUs available. If >1,
> 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.
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.