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

Hey Fred --=20

> I would just like to note that speed and reliability are largely=20
> dependent on the transaction profile of your application. If your=20
> application is read heavy, MySQL is a sound choice. However if your=20
> application consists mostly of database writes, PostgreSQL's MVCC [1]=20
> architecture and row-level locking capabilities will=20
> generally provide=20
> 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.


-Jesse-