Hi all.

I have a question about how Firebird internally updates a record.



Here an example:

Create table test(cod integer, name varchar(50))

Commit;



Insert into test(cod, name) values (1, 'Big description 1');

Insert into test(cod, name) values (2, 'Big description 2');

Insert into test(cod, name) values (3, 'Big description 3');

Commit;



Delete from teste where cod=2;

Commit;



At this point when I inspect the FDB with an hex editor I can see 3 record
on Page record (0x05).

There are 3 entries in the "struct dpg_repeater". Two of them with offset
and length and one (for record cod=2) with both offset and length 0.



Whell, next I insert a new record:

Insert into test(cod, name) values (2, 'Small 2');

Commit;



After that I reinspect the FDB file and it not REUSE the old record that
contains "Big description 2". It stays here and a NEW record was create to
hold the new record 2 that are SMALL than old record.



Why? Why Firebird does not reutilize that space?

I tested with only one connection in a test database with only this table.

Thanks, Fabiano.







[Non-text portions of this message have been removed]