Dear FireBird community members! I found out very interesting effect
in FireBird 1.5/2.0 Windows platform. Didn't test it with other OS
though.

I have created DataBase, then table

CREATE TABLE TBL_TEST(
ID Integer NOT NULL,
FVALUE Double precision,
PRIMARY KEY (ID)
);

Then I populated the table with 100 records.

If I run transaction
"SELECT * FROM TBL_TEST WHERE ID=?" or
"UPDATE TBL_TEST SET FVALUE = ? WHERE ID=?"
many times I got increase in size of the database in one page (4K)
approximately for every 16K transactions. The increase is linear.
Which means thet if I run 160K transactions it will be 10 pages.

Have anyone observed this effect before? What causes it?

Thank you