Thanks for responding,

I just cheked with a Database Workbench query.
Select * from myTable where mykeyfield = 13

This took 45 seconds to prepare and 1.45 seconds to process.Result set
was 35 records.

I disconnected and reconnected and tried with key field = 0,Same
prepare time and zero records returned.


A response from a question last April??
--------------------------------
It might have to do with how blobs are actually transferred. Each
segment might be transferred individually, in separate packets, and
all of the segment, not just to used portion.

There is room for improvement for the wire protocol and it is supposed
to be reviewed, or most likely a new one created, for FB 3.0.
---------------------------------

Thanks again,

Austin


--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@i...> wrote:

> ggroper wrote:
> >
> > Currently, (Version FB 1.52 with Delphi 7/ or 2005 and dbExpress) it
> > takes about a second per row to return a result over a remote
> > communication Internet connectection with Blob fields and sub second
> > without Blob fields.
> >
> Have you made the same test using ISQL? I'm just curious to know what
> the interface is contributing to the problem.
>
>
> Regards,
>
>
> Ann