[Firebird-devel] ODP: CORE-6199 - few question about Firebird 4
>> IMO, it will be much better if you describe the task you need to solve Task is in CORE-6199 but i need only part of it. My current solution is with OAT + RDB$RECORD_VERSION and now i am looking into FB4 changes if it can help more. It is better now because of existence of RDB$GET_TRANSACTION_CN. But it still do not use and index to query. And my question was about optimize this part to use an expression index somehow. Regards, Karol Bieniaszewski Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] ODP: CORE-6199 - few question about Firebird 4
>> Last already commited transaction CN. OK >> SNAPSHOT_NUMBER What it mean, is it from current transaction point of view first snapshot, last snapshot transaction what it is? Can you explain value based on below points? 1. Start transaction 1 snapshot 2. Commit transaction 1 3. Start transaction 2 snapshot 4. Start transaction 3 snapshot 5. Start transaction 4 read commited >> See RDB$GET_TRANSACTION_CN, described at >> doc/sql.extensions/README.builtin_functions.txt Super Regards, Karol Bieniaszewski Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel