Subject Re: [firebird-support] Divide database into separate files for better performance
Author Ann W. Harrison
At 09:12 PM 6/5/2004, body1233 wrote:
> Does FB allow dividing a database into separate files for
>indexes and/or individual tables within a single DB?

Check the archives - I've answered this once or twice - look for
"table space". Basically, most databases bounce between data and
indexes. Firebird locates all the index matches first, then goes
for the data. Systems that bounce between the two benefit from
having them on different disks. Not an issue for Firebird.

Regards,


Ann