Alexander Peshkoff wrote:

>> 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.

This is cheap VPS, so only a single core with approx 1.7GHz CPU power is
available.

Thanks,


--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================