Subject | processing time: Blob v/s File for retrieving Jpeg and gif images |
---|---|
Author | fredlaub |
Post date | 2002-10-04T13:59:47Z |
Hi,
I suppose that retrieving images from Blob database fields is more
time consuming than retrieving it directly from the filesystem.
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?
Your help/advice will be appreciated.
Frederic
I suppose that retrieving images from Blob database fields is more
time consuming than retrieving it directly from the filesystem.
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?
Your help/advice will be appreciated.
Frederic