Subject RE: [firebird-support] fbserver using 100% CPU in a big database!
Author Leyne, Sean
> I am using firebird 1.5 releases 8 and 9 in an athlon
> 1.8 Mhz with 512 Mb Ram ,running linux Red Hat 9,
> with aproximately 64 tables and 109 stored_procedures
> the fbserver process will use 100% of CPU when the
> database file is over 600 Mb .

There are many possible reasons, so here are some questions to consider.

How many rows are you counting? How many rows are in the table?

Have you reviewed the database statistics?

What is the DB page size?

What is the size of the page cache?

What is the sweep interval?

What is the difference between the Oldest Transaction and Next

What is the difference between the Oldest Active Transaction and Next