Subject Re: [Firebird-Architect] Re: Fw: Performance
Author Alexandre Kozlov
----- Original Message -----
From: "eric_ck_leung" <eric.leung@...>
Date: Wednesday, June 25, 2003 2:25 am
Subject: [Firebird-Architect] Re: Fw: Performance

> I am new to this group.
>
> I am wondering if FB allows users to specify any BLOB fields being
> stored to any external files or storage devices. I think if blob
> fields and other fields share the same storage pages. After prolong
> inserts, updates and deletes operations, And Blob fields are usually
> have irregular length, the pages might then be fragement greatly. And
> the database efficiency might be lowered.
>
Completely agree with you. Scan operation would decrease hundreds time
on large database (I checked it out) if you could manage to place
non-scan information (which is often hundreds times more in volume than
scan information) on different device. But unfortunately you can't do
this with FB. The most what you can do with this is to place BLOB field
and ID of it into different table, place database files on its own disk
and periodically do backup/restore.

Alexander