Subject | Re: [firebird-support] Performance of events |
---|---|
Author | Douglas Tosi |
Post date | 2009-12-15T12:42:12Z |
Hello Daniel,
On Tue, Dec 15, 2009 at 10:14 AM, Daniel Albuschat
<d.albuschat@...> wrote:
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
On Tue, Dec 15, 2009 at 10:14 AM, Daniel Albuschat
<d.albuschat@...> wrote:
> Are events something meant to be used rarely, or isI've used events in the past, including heavy load scenarios with 200
> something like 10 posted events per second with 100 different clients
> listening to potentially hundreds of events per connection feasible?
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