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.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
