03.12.2019 10:04, liviuslivius wrote:
Vlad,
currently this query cannot use and index
SELECT o.* FROM orders o WHERE RDB$GET_TRANSACTION_CN(o.RDB$RECORD_VERSION)
> your_last_queried_CN;
also creating expression index is not good here as CN is not stable.
What if CN will be written into database master page and not reset after last connection from database? Same as currently
transaction ID.
>
Also instead of only memory list of CN pair with transaction id it will be
written into DB.
I know more disk writes, but this will be same as for TIP already or not?
It will kill performance.
IMO, it will be much better if you describe the task you need to solve
instead of
offering a way you think you can use to solve it. Probably it could be solved
in a
different way without need to introduce new global bottleneck.
Regarsd,
Vlad
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
