On 2002.10.04 16:23:34 -0400 fredlaub wrote:

> 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?

I don't think it will make much difference as long as you manage
transactions explicitly. blobs with autocommit are apt to be unpleasant.

Otherwise you will be fetching the blob only when you access it.

david jencks

>
> --- 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/
> > >
> > >
> > >
> > >
> > >
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>