> in my applications i have some data import procedure, for speed-up the
> data import process and reduce the network traffic i need to disable the
> DML-CACHE Trigger when my user execute this procedure. Which are the
> best way for do this ?

Do the import procedure with a specific connected user
user (e.g. IMPORT), and wrap the DML-Cache trigger body
with something like ...

BEGIN
IF (USER <> 'IMPORT') THEN
BEGIN
... your DML Cache trigger code here ...
END
END

Whenever you are connected with the user IMPORT,
the code of the DML Cache trigger inside the IF
condition doesn't get executed.



HTH,
Thomas Steinmaurer

The IB LogManager Product Family
Logging/Auditing Suite for InterBase/Firebird
http://www.iblogmanager.com