Re: RES: PHP + PostgreSQL

On Thu, Sep 19, 2002 at 02:28:36PM -0300, Elielson Fontanezi wrote:
> Agreed!
>
> I am concerning about scability and avaibility and performance.
> Maybe at least 400 users will be online at the same time.

It depends on what these 400 users are doing whilst they're online, how
often they're hitting the reload button, posting stuff, etc.. I'd try to
build a scaled down version of your scenario (e.g. with 5 or 10 users,
or an e.g. php script that simulates those users' behaviour) and then
extrapolate.

PostgreSQL at the moment does not support replication (i.e. it's not in
the main tree - there are solutions out there, about which I don't know
anything though) AFAIK, so you might have to buy expensive hardware
(e.g. a server with multiple processors), or get licenses for a product
that does, if you find that you really need this kind of scalability.

As far as Open Source databases are concerned, it's the best deal in
terms of the kind of support you get on the lists - really awesome.
Featurewise, you're on a par with most of the other major contenders
(except for replication, which might bite you if you really find that
you need the scalability, which is actually rare for web applications).

Performancewise, it's faster than MySQL for UPDATEs (because MVCC is
better than table locking), which is what usually bogs down a server
with many simultaneous transactions. SELECTs are usually not hard to do
fast anyway because especially with web apps, you'd want to have some
kind of caching mechanism.

Regards, Frank