Radicore Forum: Audit Logging » Transactional tables or not?

Home » RADICORE development » Audit Logging » Transactional tables or not?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Transactional tables or not? [message #33 is a reply to message #32]

Thu, 11 May 2006 12:13

AJM
Messages: 2388
Registered: April 2006
Location: Surrey, UK

Senior Member

I use MYISAM tables by default, but I think for the audit tables it would be better to use INNODB tables for their transactional facilities. I shall change that in the next release.

You should also be aware that the Radicore framework surrounds every transaction with a 'start/begin' and 'end/commit' by default, so you can switch between non-transactional and transactional tables without any ill effects. You can even switch to other database engines, such as PostgreSQL and Oracle, where all the tables are transactional.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator