That's interesting. I actually never used Postgres on production 
environments, so... How often does it melt? And is there a known reason 
or it's just a matter of *luck*?

My opinion is that Mysql is after all nothing more than an ISAM file 
system, which can be queried by SQL. And it's more than enough for most 
small sized projects.

I dunno about InnoDB and BDB, but once referential integrity is the 
issue I'd move straight to Oracle and avoid the hassle of debugging some 
new engine features myself. At least, in a production environment. 
Oracle will also perform much better than anything else, if properly 
configured and maintained. But moving to such an environment requires a 
full time administrator if you do not want your performance to downgrade 
dramatically after some time.

In a web environment usually people do not want to spend that much 
money, so actually most of the stable stuff will probably remain on the 
ISAM file systems for a while more. After all it works, right?


Joa~o Paulo Vasconcellos wrote:
> I don't feel that. I run a web site with a big deal of traffic, and in speed 
> and scalability, MySQL is better than PGSQL or Sybase. I know because I tryed 
> each one of these before getting to MySQL in definitive. Sybase is WAAAAAY 
> too slow, and Postgres has a habit of melting down from time to time. In the 
> features field, if you need referential integrity you can use InnoDB or BDB 
> tables in MySQL, wich supports ON DELETE CASCADE and many things more, like 
> row-level locking, blah, blah, blah. To keep your data secure, Sybase is a 
> better option than PGSQL, because when PGSQL melts down, you lose some 
> records as a gift. I had not seen this behavior mainly because I did not ran 
> PGSQL long enough to see this, and the memory requirements of Sybase are just 
> too much to stand. I prefer MySQL above every other, even lacking SP's. Of 
> course, my business do not require anything more than standard MyISAM offers, 
> so PGSQL may be a better option in some cases.
> On Friday 05 July 2002 17:59, Lazor, Ed wrote:
>>How many here feel PostgreSQL has surpassed MySQL as the better backend for
>>PHP?  This would be based on performance (speed, scalability, etc.) and



LoRd, CaN yOu HeAr Me, LiKe I'm HeArInG yOu?
lOrD i'M sHiNiNg...
YoU kNoW I AlMoSt LoSt My MiNd, BuT nOw I'm HoMe AnD fReE
tHe TeSt, YeS iT iS
ThE tEsT, yEs It Is
tHe TeSt, YeS iT iS
ThE tEsT, yEs It Is.......

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to