Hi Austin,

I use D7 with dbExpress component set for Interbase. The gds32.dll is
the one that the FB installation provides. I had performance slowdown
problems when I was using the gds32.dll provided by Borland. The moment
I switched to the FB one there was no problem.

My queries typically look like this :

select code, name, city, email1, email2, ... etc.
from candidates
where workdone containing 'J2EE';
//workdone is the blob where resumes are stored.

I have recently shifted my architecture retrieve only one blob at a
time. However I am running some tests now after your e-mail and am
checking whether I experience these problems as well. Should be able to
update you by tommorrow about what is happenning.

My blobs are typically large in comparison to yours. I tend to have 1000
or more chars in them and I also store them with RTF formatting just
like you. However I use the TRichedit control to display them not the
Infopower ones.

Regards,


RP

ggroper wrote:

>Rajesh,
>
>Thanks for the input.
>
>I am using a remote host that is using Win 2000 server, and FB 1.52
>classic. I do not know their detail configuration settings.
>
>What client program are you using?? Delphi? and if so what compoonent
>set???
> Are you retreving multiple Blobs at a time or only one? Mine are
>short plain text message that will require RTF formating so I need to
>put them in Blobs for infopower to get them. Average about 50
>characters per Blob.
>
>I have done some more testing and the problem looks more complex,
>possibly a combination of Delphi and Firebird.
>
>Using dbExpress componets with OLEDBExpress driver and FB's ODBC I can
>get the time down from 30 to 7.9 sec with Blobs and 1.71 seconds with
>out Blobs. The Borland IB dbExpress driver takes 30 seconds with
>Blobs(and so does a FB third pary driver) and 1.18 seconds without
>Blobs. I tried FIBPlus to Client Data Sets and it took 8.7 seconds
>with Blobs and 1.54 seconds with out blobs, about a second less with
>out client data sets.
>
>The worst time on a local connection was 0.37 seconds with Blobs and
>0.07 seconds without blobs.
>
>Even an 8 second response time is not good enough to read 35 records???
>
>Maybe there is some harware problem in the loop?? I'm going to see if
>I can set up a test with mySQL and MS SQL Server.
>
>Thanks for the help,
>
>
>Austin
>
>--- In firebird-support@yahoogroups.com, Rajesh Punjabi <rajesh@i...>
>wrote:
>
>
>>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
>>