| Subject | RE: [IBDI] Special kind of triggers? |
|---|---|
| Author | Josipovic, Nick |
| Post date | 2001-07-10T12:48:16Z |
When you log your changes to a database-internal table, you will have full
transaction control over them, and so in case of a rollback, the entries are
also deleted.
IMHO, it would be much faster to run a batch through this log-table to save
the data externally (and delete the logs after this) than load the server
with keeping data in external tables (supposing you want to do that kind of
stuff)....
See the IBLogmanager from Thomas Steinmaurer (http://www.iblogmanager.com)
in how you can log your stuff and pull instead of push it into external
storages....
CU,
Nick Josipovic
Corporate Market Intelligence
Phone: ++49 6227 762945
transaction control over them, and so in case of a rollback, the entries are
also deleted.
IMHO, it would be much faster to run a batch through this log-table to save
the data externally (and delete the logs after this) than load the server
with keeping data in external tables (supposing you want to do that kind of
stuff)....
See the IBLogmanager from Thomas Steinmaurer (http://www.iblogmanager.com)
in how you can log your stuff and pull instead of push it into external
storages....
CU,
Nick Josipovic
Corporate Market Intelligence
Phone: ++49 6227 762945
> -----Original Message-----
> From: Alexander V.Nevsky [mailto:alex_vnru@...]
> Sent: Tuesday, July 10, 2001 2:43 PM
> To: IBDI@yahoogroups.com
> Subject: [IBDI] Special kind of triggers?
>
>
> Hi, All. Can somebody from FB team answer is it possible to have in
> FB ability to create special kind of triggers that fires on commit
> only? I think about logging of changes outside of .gdb
>
> Best regards.
>