Subject Re: [firebird-support] First insert in large table takes extreme time
Author Ann W. Harrison
Kjell,

Before going into a full investigation, does the
problem happen whenever you start the database or just
with an insert to that particular table? What happens
with a SELECT FIRST 1 on that table, with no order by?
What happens with an indexed select? What about queries
on other tables - or RDB$RELATIONS?

What does gstat -a report about that table when the
database is first started?

How many records are there in RDB$PAGES?

Cheers,

Ann