Subject Re: Workflow for OLTP + Datawarehouse using Firebird
Author mspencewasunavailable
--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@...> wrote:
>
> javaguru_uk wrote:
> > --- In firebird-support@yahoogroups.com, Alexandre Benson Smith
> > <iblist@> wrote:
> >
> > Alexandre> What scale ?
> > Alexandre> Provide some expected numbers.
> >
> > They also process between 100 and 200 daily transactions, which
> > include false alarms as well.
> >
>
> pretty low...
>
> FB hanldes it with the hands tied at the back :-)
>
> see you !
>
> --
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>

But over what time period and with what distribution? 700 users x
200 transactions = 140,000 per day. If the distribution's flat over
24 hours, then thats 1.6 /second and that's not so bad.

But if they clump together in a suboptimal way (e.g., a bell curve
with 40% of the total in one hour as a peak -- a distribution I've
had to deal with in a past life) then that's around 15/second at the
peak time.

Michael D. Spence
Mockingbird Data Systems, Inc.