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

Transactional tables or not? [message #32]

Thu, 11 May 2006 11:01

martin
Messages: 4
Registered: May 2006
Location: UK, Reading

Junior Member

Hi,

I'm developing a Java version of this framework and just finished upgrading it to the newest Audit Database schema (i.e. AUDIT_SSN, AUDIT_TRN, AUDIT_TBL, AUDIT_FLD).
When I was done with the programming I wrote a lot of tests to verify correct behavior.
I then noticed that the tables are created with the non-transactional table type MyISAM. So when I did rollback tests after simulating broken update of application data it did not rollback audit logs.
I changed all tables to use the transactional INNODB table type and then everything works okay.
So my question is: In these kind of administrative systems is it better to have the slighter higher speed and better performance with MyISAM tables or will people be requiring the transactional tables?
I mean if you have invalid audit logs hanging around or invalid application data hanging around that can't be good.
Or do we believe that these situations are so rare so it is better to go with the MyISAM tables?

Report message to a moderator

[Message index]

		Transactional tables or not? By: martin on Thu, 11 May 2006 11:01
		Re: Transactional tables or not? By: AJM on Thu, 11 May 2006 12:13

Next Topic:

List Audit Details for an Object (Audit Trail) question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Jul 08 01:42:47 EDT 2025

Total time taken to generate the page: 0.09617 seconds