|Re: Special kind of triggers?
--- In IBDI@y..., "Josipovic, Nick" <nick.josipovic@s...> wrote:
> When you log your changes to a database-internal table, you will
> transaction control over them, and so in case of a rollback, the
> also deleted.
> IMHO, it would be much faster to run a batch through this log-table
> the data externally (and delete the logs after this) than load the
> with keeping data in external tables (supposing you want to do that
I think about external logic in the sense of database corruption and
because about gfix I can't speak at forum where ladies are present. :)
My idea is call UDF within such a triggers, this UDF should transfer
data to some application server that stores this "transaction log
emulation" on another computer asyncronously with .gdb processing and
not perform delays. This log can be re-played on last copy of database
in case of corruption.
> See the IBLogmanager from Thomas Steinmaurer
I discussed this idea with Thomas, but he estimated it too