Subject Re: [firebird-support] Performance of events
Author Douglas Tosi
Hello Daniel,

On Tue, Dec 15, 2009 at 10:14 AM, Daniel Albuschat
<d.albuschat@...> wrote:
> Are events something meant to be used rarely, or is
> something like 10 posted events per second with 100 different clients
> listening to potentially hundreds of events per connection feasible?

I've used events in the past, including heavy load scenarios with 200
clients and hundreds of events per minute. I'd recommend against it.
Random server crashes, zombie attachments and hanging clients were too
frequent.
This was in the firebird 1.0 era and things may have improved of course.

One thing to be careful with event-based auto update: If 100 clients
get an event saying 'refresh query x', you don't want them all to
refresh at the same time.

hth,
--
Douglas Tosi
www.sinatica.com