Subject Re: Blob data access VERY slow when switch from libfbembed to libfbclient
Author simon_liddington
--- In, Helen Borrie <helebor@...> wrote:
> 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
> >interface!!!
> Retrieving one record or several thousand?

Retrieving a single blob.

> A more meaningful test would be from a remote interface.

Ok I did a remote interface test and got more acceptable results about
30 times slower than local file with libfbembed. Still sounds rather
slow to me ...

The question,
> either way, is why you want to use the local loopback server with
> Classic anyway....

I don't particularly but I have to join 2 apps into 1. 1 currently
uses libfbclient and when linked against libfbembed it seg faults.
From past experience I beleive this is because with the embedded
client you need to setup all connections for all threads before you
start using them (you can't add a thread later and start a new
connection). So I was trying using libfbclient for both but found it
slow on the other app as it has lots of files stored as blobs.

Anyhow, thanks for your help.