Subject Re: [firebird-support] Re: Performance Problem with BOLBs??
Author Rajesh Punjabi
Hi Austin,

I use blobs to store resumes in Firebird. I have currently about 95,000
of those and they can each go upto a 4-5 page word document each. I have
experienced problems only when I try to query something inside my blob,
not otherwise. Whether I fetch a blob field or not in the select list
has not yet presented a problem.

What is your server config. What is the swap space setting. Are u using
XP or some other server OS. Can u put out the plan on your query as well.

I use RH8 Linux and have had a problem with swap space sometimes.
Whenever I start running low on physical ram or swap space FB tends to
slow down considerably. Just my 2 bits.



ggroper wrote:

>My weakest Link is my cable modem, fast download but slower upload. I
>believe I read that it's around 150kb upload and 500kb download??
>For 3,000 charcters this can not account for the Blob performace
>problem. (2 sec local and 30 second remote??)
>Is Firbird requesting every blob separately and waits to request the
>next blob after it receives the first, thus sending 35 separate read
>requests like running 35 queries - so it takes about a second for a
>turn around?? Why so fast local and so slow remote??