On Mon, 2007-11-05 at 19:25 +0100, Gerard Freriks wrote: > > Why? > > > (Not that I intend to do that) >
> > On Nov 5, 2007, at 1:20 PM, Tim Cook wrote: > > > (please do NOT use MySQL for healthcare > > information) I will "assume" that your WHY? question was in response to this statement I made? In general (and for the speed results MySQL claims) it trades off ACID qualities to attain them. There are **MANY** documents available on the Internet to adjudge the differences between the needs of a high speed blog service etc, and the needs of a real DBMS with ACID integrity and MVCC. There are many benchmarks ( I have no interest in either system ) that show that large scale SMP systems perform better with PostgreSQL vs. MySQl. IMHO, you should use an OODBMS for most installations anyway. I Cheers, Tim -- Timothy Cook, MSc Health Informatics Research & Development Services http://timothywayne.cook.googlepages.com/home LinkedIn Profile:http://www.linkedin.com/in/timothywaynecook
