| Subject | Re: [firebird-support] Single File vs Multiple Files |
|---|---|
| Author | Alexandre Benson Smith |
| Post date | 2006-02-10T15:11:19Z |
Ruaan Barnard wrote:
No diference from the performance POV. You could spread your multi-file
database to multiple discs, but you could also use a RAID to achive the
same (or better in my opnion) with single file.
Multiple file are needed when you face a Filesystem size limit.
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
> HiRuaan,
>
> We are currently using FB SuperServer 1.5.3. When dealing with big databases
> and I mean big(30GB+) which way of structuring the db is best?
> Single File or Multiple Files? Which setup will provide the best
> performance?
>
> TIA
>
> Ruaan
>
>
No diference from the performance POV. You could spread your multi-file
database to multiple discs, but you could also use a RAID to achive the
same (or better in my opnion) with single file.
Multiple file are needed when you face a Filesystem size limit.
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br