Subject Re: [firebird-support] Having one big table in a separate file ?
Author Ann W. Harrison
Charles-Henri Balet wrote:
> Hello,
>
> I use firebird 2.1 and one of the table of my dev,
> store binary files and grow quickly, my question, is able
> firebird to support of split of database and link
> this table in another file (I want to have only one table in
> another file but that make integrate part of my
> database like an external table but read that external table
> can't use binary blob)

Basically, no, you can't force a single table to be in
a file by itself unless you use external tables and the
available external table implementations don't support
blobs.

>
>
> I have stored procedure that use
> this table and want to keep them in the main file....
> my goal is only hat have a table (or more and functions)
> that are stored in multiples files but keep one database
>
I guess my question is why you think that having one table
in a different file is a good idea?


Best,

Ann