Subject Table limits
Author Robert martin

We have some data where we have had a bit of a 'blow out' and a large
number of tables have been created. Normal our database has about 200
tables however this one has around 7000. Out of interest what is the
limit on the number of tables for a FB DB?

We only noticed this because the user reported a large decrease in
performance of the system. We also notice this, simple things like
selecting data from a 1 record table takes 5+ seconds. We have backed
up the database and restored but the performance is still bad. Do you
think it might just be we are pushing the limits on the number of tables.

The database if just under 500 Mb. Our standard tables contain all the
data and the extra 7800 tables have between 0 and a few dozen records at

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496

Wild Software Ltd