Subject | Measuring Trigger Overheads |
---|---|
Author | rodbracher |
Post date | 2002-06-24T12:39:08Z |
Hi
Is there a tool that can be used to measure overhead of introducing
triggers to the db. This would be relavent if I put an
update/insert/delete trigger on say 100 relations - each writing to
a "log" relation - obviously this will create a lot of triggering if
there were 20 clients working at the same time.
Of course this would all be server side processing but would have to
see if this would effect the speed clients could access info ( At a
human-noticeable ).
Thanks
Rod
Is there a tool that can be used to measure overhead of introducing
triggers to the db. This would be relavent if I put an
update/insert/delete trigger on say 100 relations - each writing to
a "log" relation - obviously this will create a lot of triggering if
there were 20 clients working at the same time.
Of course this would all be server side processing but would have to
see if this would effect the speed clients could access info ( At a
human-noticeable ).
Thanks
Rod