Subject Re: Why so slow blob retrival?
Author Raúl Alberto Valencia Najarro
Try playing a little bit with the database: tuning the BLOB segment
size, the database page size and the number of pages in the cache. You
should use GBAK or another utility to create tuned copies of your
database and begin the testing on them.


Possibly, you can read the blobs faster after the first time because
the pages are in the cache.


Cheers,

Raúl.


--- In firebird-support@yahoogroups.com, dade2000
<wwwdade2000puntoit@y...> wrote:
> Hi all
>
> My application store and retrive some blob (text or graphics) in a
table.
>
> Sometimes first fetch of a blob field is very sloow (1-2 min) the other
> times fetch is reasonably fast also
> on same first record (so isn't a data record problem).
>
> Why this strange behaviour?
>
> D7 + IBX7.08 + FB1.5 RC7
>
>
> Thanx Daniele