Вот, что получается "на кошках" Start Transaction: consistency no_auto_undo nowait
select * from rdb$database PLAN (RDB$DATABASE NATURAL) -----Statistics----- Reads = 0 Writes = 0 Fetches = 53 Marks = 0 CurrentMemory = 17028548 MaxMemory = 17155676 NumBuffers = 1000 -----Detail statistics----- read_idx_count RDB$FIELDS = 4 RDB$RELATION_FIELDS = 8 RDB$RELATIONS = 3 read_seq_count RDB$DATABASE = 1 -----End------ execute procedure bug_test2 -----Statistics----- Reads = 65467 Writes = 326828 Fetches = 24920870 Marks = 7474339 CurrentMemory = 21233080 MaxMemory = 21933632 NumBuffers = 1000 -----Detail statistics----- read_idx_count RDB$INDICES = 4 RDB$RELATIONS = 6 RDB$FORMATS = 1 RDB$SECURITY_CLASSES = 3 RDB$TRIGGERS = 5 RDB$RELATION_CONSTRAINTS = 1 RDB$PROCEDURES = 3 TEST_TABLE2 = 1000000 read_seq_count TEST_TABLE2 = 1000000 update_count TEST_TABLE2 = 2000000 -----End------ select * from rdb$database PLAN (RDB$DATABASE NATURAL) -----Statistics----- Reads = 2 Writes = 0 Fetches = 5 Marks = 0 CurrentMemory = 21237156 MaxMemory = 21933632 NumBuffers = 1000 -----Detail statistics----- read_seq_count RDB$DATABASE = 1 -----End------ Commit Transaction Start Transaction: consistency no_auto_undo nowait select * from rdb$database PLAN (RDB$DATABASE NATURAL) -----Statistics----- Reads = 0 Writes = 0 Fetches = 5 Marks = 0 CurrentMemory = 21235812 MaxMemory = 21933632 NumBuffers = 1000 -----Detail statistics----- read_seq_count RDB$DATABASE = 1 -----End------ 21 мб против 17 в начале - этого хватит? С уважением, Евгений
