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?
regards,
Karol Bieniaszewski
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
