Subject | Re: Workflow for OLTP + Datawarehouse using Firebird |
---|---|
Author | mspencewasunavailable |
Post date | 2008-01-22T21:39:19Z |
--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@...> wrote:
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.
<iblist@...> wrote:
>But over what time period and with what distribution? 700 users x
> 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
>
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.