On Thu, Mar 3, 2016 at 1:02 PM, Jim Starkey <j...@jimstarkey.net> wrote:
>
> >> Non-goals:
> >>
> ...
> >> 2. Store blobs in other than the table's data space.
> > Why not allow blobs to be separated from regular data ?
>
> OK, reasonable question. Obviously they could, but it would require
> either storing small blobs off page or changing the mechanism used for
> blob ids, or both. It also runs the risk of the records and blobs
> diverging, which is very, very bad.
>
> I think the benefit of separating records and blobs is quite limited.
> Large blobs have at least their rear end stored on blob pages that
> aren't scanned for exhaustive retrievals. Moving them to a separate
> data space within the same table space so they don't share the record
> number space with records is well worth considering.
>
I think the problem is with the size of backups and the amount of time
taken by a backup/restore for a database with a significant number of
large blobs.
Cheers,
Ann
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel