Re: [cgiapp] "Best free DB for a web-based Perl app" response results...

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.