--- In firebird-support@yahoogroups.com, Svein Erling Tysvær <svein.erling.tysvaer@...> wrote:

>
> >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..
>
> Maybe some of your selects can share read-only, read committed transactions? That would not block garbage collection so you don't have to commit it all too often. Though it does mean that the most recent record at the time of the read is read, so it might not be appropriate for your selects. And it will not be worth the effort if it only reduces the number of transactions from 18 million to 17,x million.
>
> 18 million transactions per day... That's an impressive number that is roughly 18 million transactions more per day than the number of transactions most of us work with.
>
> Set
>

This is good concept

this will be not easy with dbExpress to start read-only transaction
(not only Firebird is used)
and modify all code to share transaction

but to see how many transaction i can reduce
i must analyze per connecion activity

if this reduce to 15 million i will be satisfies by performance upgrade ;-)
but transaction counter grow still big ;-)


Karol Bieniaszewski