Hi,

I have a questions regarding number of tables in a database.

I am storing simple time series data into Firbird. In worst case I'm
looking at 20 MB new data each day (~ 1.7 milion rows).

Currently the data is divided into ~100 tables.

As you might have guess by now, I have run into some query
performance problems. Not in the sens that Firebird is slow, its just
a allot of data.

To improve the situation I'm considering reorganise the data into
more tables, to get smaller data sets to search.

So the question is, is there a practical limit to the number of
tables in a database (In the sens that where table management will
affect the general performance) ?. I'm considering splitting the data
into as much as 2500 tables