Re: PHP 5.0.0 Beta 1 : alternatives to MySQL?

For what it's worth, I installed both versions of PostgreSQL suggested on pear-dev: - the binaries for 7.2.1 (ftp://209.61.187.152/postgres/) 3.78 MB - windows installer for 7.3.1 (http://ftp.iasi.roedu.net/mirrors/ftp.postgresql.org/binary/v7.3.1/Windows/) 10.8 MB and whereas the later was veeeery slow to start and shutdown, plus logon difficulties, the former works like a charm :-) I'm using windows 2000 and PHP 4.3.2 on Apache 1.3.27 obviously with pg enabled. Only small hitch was the setenv.bat file seemed to have no effect, but entering the env. vars at the command line worked fine. cheers Demian Alessandro Bottoni wrote:

Alle 21:17, mercoledì 2 luglio 2003, Eric \ ha scritto:

How does Postgres compare to MySQL? I've been using MySQL for quite some time on sites with millions of hits a day without performance problems (the big upshot to MySQL is that select queries are very fast, the big downside is that insert and update queries are sometimes unstable, so you code for as few writes as possible).

I never used it on milion-hits-per-day applications but, as long as I can see, PostgreSQL is NOT significantly slower than MySQL, neither in read nor in write operations. In all of my applications, the real bottleneck was PHP and, much more important, the network bandwith. Regarding the system stability, I cannot remember any significant problem neither with PostgreSQL nor with MySQL (while I can remember a few, even serious, problems with M$ SQL Server and, much more, with M$ Jet). IMHO, PosgtreSQL is so much richer of useful features (server-side scripting languages like PL/SQL and Python, rules, functions, transactions, PGAccess and so on) than MySQL that it is hard to understand why so much people still do not use it, in particular if you consider that PostgreSQL is BSD-licensed (absolutely _no limits_!). PS: I never used PostgreSQL on Windows, though. My 2 Euro cents. ------------------ Alessandro Bottoni