Re: [Firebird-devel] Generating transactions

[Vlad Khorsun]

01.08.2019 11:52, Jiří Činčura wrote:

Hi *,

this might seem silly, but is there a very fast way to generate transactions in 
Firebird? I'm trying to test new bigger transaction IDs in .NET provider. As 
far as I know using multiple connections in parallel is not going to help. So 
far I'm doing simple execute block:
execute block
as
declare cnt int;
begin
        cnt = 100000;
        while (cnt > 0) do
        begin
                in autonomous transaction do
                begin           
                end
                cnt = cnt - 1;
        end
end

But this gives me 100000 transactions in about 9 seconds. Hence more than 2 
days to reach 2^32.

  Set FW=OFF, MaxUnflushedWrites = -1, MaxUnflushedWriteTime = -1

Regards,
Vlad



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel