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.

Regards,


RP

ggroper wrote:

>Pete,
>
>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??
>
>Austin
>
>
>
>