Subject [firebird-support] Re: How to improve Firebird performance on a large table?
Author Svein Erling Tysvær
>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.

Have you considered using events, Anto? I.e. rather than the client continuously looking for changes, just tell the server that you want to know when things happen. I think that could reduce the traffic considerably (although I don't use events myself).

HTH,
Set