roar4711 wrote:

> I got a database with 5 different table, each containing around 19 million records. Each five minutes between 1500 and 2000 records are added to each table. Right now the database is 12 GB but I expect it to grow to 80-90 GB for a whole year worth of data.
>
> A table looks like this:
>
> integer ID
> integer Time
> float Data
>
> I have an asc and desc index on ID/Time for (time) ranged queries. Cant have a primary index since there is no unique data.

I'd say you'd better reverse the order to Time/ID (or create it next to
the existing) as that will probably give better selectivity (although
that depends on your exact usage), and allow Firebird to use that index
for your SELECT MAX(time)... as well.

> Default page size is set to 4096 bytes.

You might want to consider moving your database to a larger page size.

--
Mark Rotteveel