Subject Re: [firebird-support] Performance of events
Author Milan Babuskov
Daniel Albuschat wrote:
> Firebird 1.0 is quite old now. I'm only using Firebird 1.5 myself, but I
> guess that much (could) have changed for Firebird 2.x.
> On the other hand, I have the feeling that events are a feature that don't
> receive much love from the developers.

I'm using events a lot in my applications (using Firebird 2.0 and 2.1).
However, I have two "patterns" that make it work really fast:

For some events, each client has its own event name. The idea is that
not all clients are interested in the same thing. So client applications
have unique event names, and they get notified only when record is
interesting to them.

In other uses (a lot of clients interested in the same event) I add a
special field in database tables (last_update). The trigger updates
LAST_UPDATE column before event is fired and clients just query WHERE
LAST_UPDATE > :last_time_client_responded_to_event. There is DESC index
on LAST_UPDATE so this works really fast even when tables are big an
there are a lot of clients.

HTH. YMMV, of course.

Milan Babuskov

The easiest way to import XML, CSV
and textual files into Firebird: