hello
we are using anonymous database triggers
with the login / logout 1000 users fbserver memory is increasing to
aproximately 1476-1536K .
CREATE OR ALTER trigger DB_login_LOG
active on connect position 0
as
declare variable ClAdr varchar(100);
declare variable ClPrg varchar(100);
declare variable SPrsId integer;
declare variable CPrsId integer;
begin
SELECT
MON$REMOTE_ADDRESS,mon$remote_process,mon$server_pid,d.mon$remote_pid
FROM MON$ATTACHMENTS D
WHERE mon$ATTACHMENT_ID = current_connection
Into :cladr, :clprg, :cprsid , :cprsid;
-- insert into xx_xuserlog .......
-- values ( current_connection,current_timestamp, .....
when any do exit;
end
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
