Robert,

> Out of interest what is the
> limit on the number of tables for a FB DB?

64 * 1024

> We also notice this, simple things like
> selecting data from a 1 record table takes 5+ seconds.

How long does it take to execute something like:

SELECT COUNT(*) from RDB$Database

?

> The database if just under 500 Mb.

We have databases which are 15GB and are growing by 500MB per month.


Sean