On 17/06/2004 19:12, Shachar Shemesh wrote:
Sagi Bashari wrote:
I can only speak from my experience. I never lost any data because of MySQL. MySQL supports transactions for few years now so this is not an issue for me.
I was mainly referring to data integrity in the face of power failure/server segmentation fault in the middle of a transaction. These are the type of problems that are extremely uncommon, but extremely dangerous for that very same reason.
Pg's disk data structure is built like a journaled file system, in order to give an assurance against precisely these type of problems. As far as I understood, MySQL's speed comes precisely from the lack of this structure. To me, these are more important than logical transactions when everything is ok. That is also what I meant when I said I'm not sure how you can retrofit such features into an existing database.
I believe InnoDB offers the same advantages. You may read about it here: http://www.innodb.com/howtouse.php
Sagi
================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
