On Fri, 6 Apr 2001, Mark John Buenconsejo wrote:
> hello,
>
> 'm interested, can you support why it's sucky. i been trying to choose the
> best open source RDBMs. i've used mySQL, but not for real database
> applications, only small ones. haven't stress tested mySQL also. for
> postgreSQL, haven't used it.
>
> can you suggest which is a better RDBMS in relation to reliability, speed,
> ease of maintenance, wide development support, support for concurrency,
> transaction, and flexibility.
>
To call mysql a "relational database" is flattering it. It has no
transaction support, and fails every part of the ACID test (atomicity,
consistency, isolation, and durability), especially the last part. We
found that out the hard way. Since MySQL does table-level locking, using
the db in a certain way can make it extremely slow.
Postgres satisfies any decent definition of an RDBMS, however, it has
scalability problems and is slow when you compare it to a real enterprise
RDBMS like Oracle or DB/2.
Read this recent article on Slashdot for some more info on these issues:
"Are Expensive RDBM systems Worth The Money?"
http://slashdot.org/askslashdot/01/03/04/0842229.shtml
and an interesting article on PHPBuilder:
http://www.phpbuilder.com/columns/tim20001112.php3
that compares PostgreSQL and MySQL.
--
Rafael R. Sevilla <[EMAIL PROTECTED]> +63(2) 8177746 ext. 8311
Programmer, InterdotNet Philippines +63(917) 4458925
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
