> 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
>

I think you just need the right indexes.
I wouldn't see an iissue putting all this data into one table.
Alan