Subject Re: [Firebird-Architect] FB2, read-commited and blobs
Author Martijn Tonies
>
> > What is the "Borlandish solution"?
>
> In recent IB versions, read committed transactions don't block GC and this
> is good. But they don't track blob references as this is not as good. So
> there may be a moment of time when you have a blob id to fetch the blob
> contents, but the blob is already garbage collected. As a result, you will
> either get a runtime error or a wrong blob content, depending on whether
> this blob id has been reused or not. At least this is what I remember from
> the previous discussion.

What's the reason to re-use BLOB IDs?

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com