At 01:58 AM 23/02/2004 +0000, you wrote:

>There is known massive blob leaks in FB 1.0.3,

Where did you hear that?

>get Firebird 1.5 and
>all these issues will go away. Just don't set a massive buffer :-)

Problems with oversized buffers exist in 1.0.x and 1.5, regardless of
whether you use blobs. It's a function of the way the server uses the
cache. If it is too big, then you are wasting resources caching more data
than is likely to be needed again soon. The server holds and releases
cached pages on the basis of need. In a smaller cache, it will release
cached blob pages sooner because other transactions have a greater need for
the cache.

It's just simplistic for anyone to suppose that there is a direct
relationship between cache size and performance. ("Hike up the cache and
run like a rocket"). There is a critical mass in any system where the
resource cost of caching excessively will overtake all of the
benefits. Like eating one chocolate is a wonderful experience but eating
the whole box of chocolates will make you ill. :-)

>Now that 1.5 final is out, there is absolutely no reason to use 1.x
>anymore, unless you are on a platform that has not been released yet.

!.5 is great and I wouldn't even dream of beginning a new system with 1.0.x
now. But there are good, practical reasons for some to stick with 1.0.3
for a while. For example, if you can't upgrade your IBO applications to
4.3, then the need to configure the whole 1.5 server for
OldParameterOrdering is a loose cannon.

Helen