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

>
> karolbieniaszewski skriver:
> > 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 :/
>
> SSD? With RAID? With battery backup on controller or inside HDD?
>
> Anyway, I hope you can find a solution. Good luck!
>
> One thought: perhaps you could have built your own transaction system on
> top of a non-transactional DB backend, and use transactions only for
> those queries that so require?
>
> Kjell
> --
> --------------------------------------
> Kjell Rilbe
> DataDIA AB
> E-post: kjell@...
> Telefon: 08-761 06 55
> Mobil: 0733-44 24 64
>

No this is not SSD
SSD have guaranteed number of saves too small

this is modified RAM disc with back up on it and save to normal HDD
i check this configuration and i reach time operating limitation when transaction grow to 1800 per second ;-)
But may be then hardware will be also faster ;-)

Karol Bieniaszewski