Subject Re: [firebird-support] Blob data access VERY slow when switch from libfbembed to libfbclient
Author Helen Borrie
At 09:59 AM 29/09/2006, you wrote:
>Hi Folks,
>I have been using the embedded version of firebird and just tried
>switching to libfbclient but it is desperately slow.
>Blob retrieval is 1000 times slower and that's on the loopback network

Retrieving one record or several thousand?

Local loopback is a virtual network interface and it's probable that
the packet size is forced to be very small to conserve resources; or
that you are getting long waits due to having large blobs and small
memory resources on the local machine; or a combination of
both. (libfbembed, by contrast, does not use an emulated network
interface but reads directly from the database file...)

A more meaningful test would be from a remote interface.

>I have a page size of 4096 and have set the blob segment size to this.

It won't have any effect. The size of the blob segments from the
client side will be governed by your network packet size and the
engine will make its own decision about segment size. One thing it
won't be is 4096, since pages store other data besides the actual blob data.

>Anyone have any ideas?

Though it's possibly irrelevant, I recently discovered you can make a
local loopback connection using the libfbembed client. The question,
either way, is why you want to use the local loopback server with
Classic anyway....