On Tue, 21 Jun 2011 21:12:58 +0300 Jari Fredriksson <ja...@iki.fi> wrote:
> Are you sure you are not using MyISAM tables? I don't use MySQL at all. (Our CRM system requires it, but apart from that, I stay away from it.) > When they lock, they lock the entire table, which is BAD for > performance if there are multiple clients or threads using the > database. InnoDB engine is much better. InnoDB may be better, but it's not as fast as CDB, and certainly slower than a local CDB file. Just the TCP round-trip time will make MySQL slower than local CDB files. Furthermore, the design of CDB is inherently lock-free so there are no contention problems for multiple readers. Finally, local files scale much better as you add servers because each new server gives you a new chunk of disk bandwidth. Any centralized database (MySQL, PostgreSQL) is much harder to scale in this way. Regards, David.
