>Dear Alan,

>Thanks for your reply.

>This is my table ddl :
>>CREATE TABLE LOG
>(
>ID Integer NOT NULL,
>ID_TBL Integer NOT NULL,
>TBL_NM Varchar(40) NOT NULL,
>OPR Char(1) NOT NULL,
>>LOG_AT Timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
>SNC Smallint DEFAULT 0,
>PRIMARY KEY (ID)
>);

>I think, I found the problem.

>I made a small app that seek for snc's value every second. It seems makes

firebird server works heavily.

>Changing seeking time from 1 second to 10 seconds seems solved the problem.

>Thanks anyway for your suggestions.

>Best regards,
>Anto.

Hi

I would also add a compounded index snc + ID, or just snc

Regards Bogdan







[Non-text portions of this message have been removed]