Subject Re: [firebird-support] why Blob is so slow ?
Author Mark Rotteveel
On 19-4-2012 18:34, Tupy... nambá wrote:
> Still something = doesn´t matter if you have the blob field in a separated table. Since they are all together in a same DB file, they may cause defragmentation, no one can ensure where at the DB file they will be written and probably will be written in the middle of others non-blob columns/fields.
> If you have an separated DB for the blob-fields-tables, you will not have this problem, but then you will have new ACIDity problems. If Firebird had something like MSSQL Server Linked Servers, than you still could have integration between the two DB´s, having the best of both (no fragmentation at one / blob´s at the other).

Firebird has distributed transactions, so if you really want to use two
databases then you can use a two-phase commit to maintain ACID.

Mark Rotteveel