Subject | Re: [firebird-support] First insert in large table takes extreme time |
---|---|
Author | Ann W. Harrison |
Post date | 2010-12-16T16:59:21Z |
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
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