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