Subject RE: [firebird-support] Big file database
Author Leyne, Sean
NAS,

> I use middle to acces database to insert or update and web for
reporting.
> Server IBM x366 Double processor, I use Redhat enterprise 3.
> what should I do :
> 1. Split file database or just use one file ?

Personally, I would only recommend split databases if ABSOLUTELY
necessary.

> 2. Install Super server or Clasic server ?

Depends on how many DB connections you will have.


> 3. How about limit size perdatabase
> 7 T or 32 T ?
> 4. How about filesize ?

The maximum database and filesize work out to be the same, well above
1TB. I can't say I've ever heard of someone running a database larger
than 900GB.


> 5. How Page size ?

I would recommend at least 8KB


> 7. others

Is your application made up of a large number of table or a small number
of table with a large amount of data?

The reason I ask is because v2.0 has a new internal record ID size which
allows for a single table to store more than 30-40GB of data. (The new
limit is > 1 TB)


Sean