SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
DB Audit Degrade Performance?

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
DB Audit Degrade Performance?
Author Message
vicki



Joined: 11 Jul 2012
Posts: 2
Country: Hong Kong

Post DB Audit Degrade Performance? Reply with quote
My DB Audit database got about 40G data after implemeting for a year.
And it is found that database has slow response.

In my concept, DB Audit uses trigger to record INSERT/UPDATE/DELETE, which performance should not be affected by the size of DB Audit database, right?

Or DB Audit trigger actually do some "select" action before / after inserting audit record?
Wed Jul 11, 2012 4:40 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6500

Post Reply with quote
The size of the database is not important for the performance if it is not very fragmented and the database server does not spend a lot of time searching for where to save the new data.
Wed Jul 11, 2012 8:00 am View user's profile Send private message
vicki



Joined: 11 Jul 2012
Posts: 2
Country: Hong Kong

Post Reply with quote
So, does the trigger seatch before save?
Wed Jul 11, 2012 7:19 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6500

Post Reply with quote
It may read filter definitions, if any filters have been defined. That's all. If filters have been defined reasonable, that read is nothing in terms of performance impact, it should be all cached in memory
Wed Jul 11, 2012 8:42 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.