On Fri, 6 Apr 2001, Mark John Buenconsejo wrote:
..
> '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.
Because it has sucky concurrency. Try doing a SELECT SUM(*) FROM BIG_TABLE
and then try doing INSERTs or UPDATES on the same table. You will see
hanging processes all over the place.
It doesn't have good transactional support (the BDB table type is fairly
new and not widely-tested). It has crappy query support, no nested queries
(although that's not too bad, most nested queries can be better written as
joins).
We *have* stress-tested MySQL here at Mozcom. We used it for a while. It's
unreliable, corrupts data, etc. It's not really designed for a
transactional environment, and it shows.
> 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.
PostgreSQL. Normally I would say Oracle, but not many people can afford
it.
--
---------------------------------------------------------------------
Orlando Andico <[EMAIL PROTECTED]> POTS Phone: +63 (2) 848-2893
Mosaic Communications, Inc. GSM Mobile: +63 (917) 531-5893
I'm not suffering from insanity -- I'm enjoying every minute of it!!
_
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]
