--- In firebird-support@yahoogroups.com, Kjell Rilbe <kjell.rilbe@...> wrote:

>
> karolbieniaszewski skriver:
> > then you confirm that this limitation exists?
> > I yes i am in bad situation
> > because now i have ~18 000 000 transaction per day
> > this is ~200 transaction per second :/
> >
> > I see that i need to take off line my database after <4 month :/
> > This counter not restart self?
> > I really need to backup and restore cycle?
>
> I'm interested: what kind of system is this?
>
> In my experience, with forced writes on, FB does so many seeks per
> commit, that I doubt it would even be possible to sustain that high
> transaction rate.
>
> But perhaps you have forced writes off?
>
> In that case, what have you done to reduce/avoid the corruption risk?
>
> Kjell
> --
> --------------------------------------
> Kjell Rilbe
> DataDIA AB
> E-post: kjell@...
> Telefon: 08-761 06 55
> Mobil: 0733-44 24 64
>

Monitoring software with also web access by many many users ~1 000 000
They do something which need transaction and some select(reports) which "not need" transaction
but in transactional database select also start short transaction then i can not remove it creation..
1 000 0000 x 10 queries per day i got 10 000 000 transaction
+ system self generate 8 000 000 transaction per day (to storing/updating/computing.. data)

and Forced Writes are ON
but database work on some not mechanical device like normal HDD
and corruption is reduced to minimal possible
but this transaction counter do may problem :/

Karol Bieniaszewski