Re: Select count(*) in Oracle and MySQL

Mladen Gogala wrote:

> MySQL is not suitable for a massive OLTP solution. PostgreSQL can be.
> In my opinion, that is a good thing.

And neither is worth anything if your organization happens to be subject to any form of governmental or banking governance, auditing or compliance regulation among them Sarbanes Oxley (SEC), HIPAA (DHHS), Electronic Storage of Brokerage Dealer Records (SEC), FACTA (FTC), Gramm Leach Bliley (FTC), Payment Card Industry Data Security Standard (PCI), PIPEDA (Privacy Commissioner Canada), Basel II (Bank for International Settlements), or numerous other rules and regs.

You are correct that MySQL has grown up from what it was. But it is still an teenager striving to be a adult. Perhaps in another 7 years it will make the leap.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org