| Subject | Re: Blob data access VERY slow when switch from libfbembed to libfbclient |
|---|---|
| Author | simon_liddington |
| Post date | 2006-09-29T05:22:21Z |
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
30 times slower than local file with libfbembed. Still sounds rather
slow to me ...
The question,
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.
Simon
>Retrieving a single blob.
> 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?
> 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 withI don't particularly but I have to join 2 apps into 1. 1 currently
> Classic anyway....
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.
Simon