Jesse Erlbaum wrote:
Hey Fred --
I would just like to note that speed and reliability are largely
dependent on the transaction profile of your application. If your
application is read heavy, MySQL is a sound choice. However if your
application consists mostly of database writes, PostgreSQL's MVCC [1]
architecture and row-level locking capabilities will
generally provide
superior performance and reliability to MySQL.
I question your assertion that PgSQL's row-level locking is faster than
MySQL's row-level locking. I'd like to see actual benchmarks before
saying that one particular approch is faster than another.
Fair enough. I will put together a benchmark using DBI and make the
source and results open for review. I don't believe there currently any
credible benchmarks in existence which can answer this question accurately.
---------------------------------------------------------------------
Web Archive: http://www.mail-archive.com/[email protected]/
http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
