Subject | RE: [firebird-support] Big file database |
---|---|
Author | Leyne, Sean |
Post date | 2005-09-12T02:14:03Z |
NAS,
necessary.
1TB. I can't say I've ever heard of someone running a database larger
than 900GB.
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
> I use middle to acces database to insert or update and web forreporting.
> Server IBM x366 Double processor, I use Redhat enterprise 3.Personally, I would only recommend split databases if ABSOLUTELY
> what should I do :
> 1. Split file database or just use one file ?
necessary.
> 2. Install Super server or Clasic server ?Depends on how many DB connections you will have.
> 3. How about limit size perdatabaseThe maximum database and filesize work out to be the same, well above
> 7 T or 32 T ?
> 4. How about filesize ?
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. othersIs 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