Hi again,

I intended to make some tests myself, but for the moment I can't make
them in a multi-users environment and sometimes you get opposite
results with heavy loads.
Can you help with this one:
Is it better to retrieve one blob at a time by defining a preparement
statement for one record retrieval, or using a preparement statement
for retrieving +/- 500 blob records in one resultset is better?
Are they any limitations? Won't the second option create a bottle neck?

--- In Firebird-Java@y..., David Jencks <davidjencks@d...> wrote:
> On 2002.10.04 09:59:47 -0400 fredlaub wrote:
> > Hi,
> >
> > I suppose that retrieving images from Blob database fields is more
> > time consuming than retrieving it directly from the filesystem.
>
> I haven't experimented, but if fb's buffer caching is better than the
> filesystems the db could be faster.
>
> > I know the advantages of storing the images in the database but
> > processing time is a key factor in my case.
> > I would like to know the overhead in %, database retrieval v/s file
> > retrieval in a web application environment, can anyone give me some
> > figures?
> > Writing the images to the database is not a concern to me (will be
> > done by a batch job).
> > I will use a separate connection pool for blob retrieval, are they any
> > special parameters I could set-up when using a connection from
> > this pool to optimize processing time?
>
> Again I haven't experimented, but try setting the blob buffer length >
> image size.

I stored the file Size in the database, using this size for the buffer
isn't enough?

Regards
Frederic


>
> david jencks
> >
> > Your help/advice will be appreciated.
> > Frederic
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > Firebird-Java-unsubscribe@y...
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
> >
> >