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.

david jencks

>
> Your help/advice will be appreciated.
> Frederic
>
>
>
>
> 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/
>
>
>
>
>