Subject | Re: [firebird-support] Re: Autonomous transactions or smth. like this? |
---|---|
Author | Ann W. Harrison |
Post date | 2005-08-02T16:52:37Z |
dosinovsky wrote:
process that moves them from the external table to an internal table
periodically. Use a generator to identify log records so you can copy
only the new ones. You'll need to drop the external table periodically
so you can truncate it.
The UDF solutions are really ugly - getting the database name is
possible with info calls I think, but still that solution is a mess and
would be very expensive as you would need to make and close a connection
for every log record.
Regards,
Ann
>One possibility is to write the logs to an external table and have a
process that moves them from the external table to an internal table
periodically. Use a generator to identify log records so you can copy
only the new ones. You'll need to drop the external table periodically
so you can truncate it.
The UDF solutions are really ugly - getting the database name is
possible with info calls I think, but still that solution is a mess and
would be very expensive as you would need to make and close a connection
for every log record.
Regards,
Ann