Subject RE: [firebird-support] Does splitting 8G of database to smaller files a good Idea ?
Author Alan McDonald
> Dear All,
>
> Does splitting 8G of database to smaller files give a performance
> boost? I've read that firedbird 1.5 dosen't limit its database size,
> but how does it handle large files? What is the rule of thumb on
> firebird database size?
>
> p/s: I'm running my Firebird on RHEL with ext3 filesystem. From
> googling I found out that ext3 on RHEL can handle up to terrabytes.
>

I've never experienced any improvement in access speed/performance by
splitting a database across files.
The feature is only there because in days gone by, partitions couldn't
handle very large files (AFAIK).
Splitting a file would be done only where filesystems were at their limit.
Alan