Subject Re: [ib-support] EXTERNAL tables for logging
Author Anderson Farias
Hi,

> External tables do have some restrictions you should be aware of:
>
> - Only INSERT and SELECT is supported
> - No BLOB and array support
> - DML operations are outside transaction control
> ...

well, for my logging system thats all I need (select and insert). And, I
don't really need blob or array suport and so on...

> You'd better keep the logs inside the database and pump them
> regularly to another database by using the two-phase-commit
> protocol.

Thanks for the idea -- backup and maintenance is some of the issues I'm
really concern with -- toggether with "search" capabilities for some kind of
"audit" tool. :)

Regards,
Anderson