Re: [Firebird-devel] How to prevent garbage slowing down the query inside transaction

2019-08-26 Thread Jiří Činčura
On Mon, Aug 26, 2019, at 12:12, Dimitry Sibiryakov wrote: > 26.08.2019 12:09, Vlad Khorsun wrote: > > Sure, but it is not about the speed of GC. It is about space occupied by > > deleted records. > >This way or that I think Jiří should try it and find out if there is > any difference. Same

Re: [Firebird-devel] How to prevent garbage slowing down the query inside transaction

2019-08-26 Thread Dimitry Sibiryakov
26.08.2019 12:09, Vlad Khorsun wrote: Sure, but it is not about the speed of GC. It is about space occupied by deleted records. This way or that I think Jiří should try it and find out if there is any difference. -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists

Re: [Firebird-devel] How to prevent garbage slowing down the query inside transaction

2019-08-26 Thread Vlad Khorsun
26.08.2019 12:51, Dimitry Sibiryakov wrote: 26.08.2019 11:43, Vlad Khorsun wrote:    When record is removed from data page ?   No immediately, it still leave the stub. Nevertheless GC of the stub should be faster than full version. Sure, but it is not about the speed of GC. It is about s

Re: [Firebird-devel] How to prevent garbage slowing down the query inside transaction

2019-08-26 Thread Dimitry Sibiryakov
26.08.2019 11:43, Vlad Khorsun wrote:   When record is removed from data page ? No immediately, it still leave the stub. Nevertheless GC of the stub should be faster than full version. -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/list

Re: [Firebird-devel] How to prevent garbage slowing down the query inside transaction

2019-08-26 Thread Vlad Khorsun
26.08.2019 12:19, Dimitry Sibiryakov wrote: 26.08.2019 9:17, Vlad Khorsun wrote:     In theory, engine could remove such records before transaction ends. Not sure it will be easy to do.   Delete-in-place is implemented in Avalerion and Firebird 4. When record is removed from data page ?

Re: [Firebird-devel] How to prevent garbage slowing down the query inside transaction

2019-08-26 Thread Dimitry Sibiryakov
26.08.2019 9:17, Vlad Khorsun wrote:    In theory, engine could remove such records before transaction ends. Not sure it will be easy to do. Delete-in-place is implemented in Avalerion and Firebird 4. -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge

Re: [Firebird-devel] How to prevent garbage slowing down the query inside transaction

2019-08-26 Thread Vlad Khorsun
26.08.2019 9:49, Jiří Činčura wrote: Hi *, let's have this structure: create database 'localhost:slower.fdb' user 'sysdba' password 'masterkey'; create table dummy (i integer); set term ~; recreate procedure foobar as declare cnt integer; begin delete from dummy; cnt = 10;