Storing Images in a databse

I need some advice <g>

I am going to store some images in an oracle database, currently we have about 10,000 images though this will grow to about 40,000. The images are generaly small 14-20k jpg's for displaying on screen and the same image in BMP format (50k~) for printing on reports.

Queries will be run that either select the report format or the screen format, the number of records in the select statement will usually be quite low, ie less than 100.

What I wonder is as the queries will be either selecting the screen format OR the print format would we get better performance by putting the images in to two seperate tables so that both columns dont need to be read in or is this just a waste of time.

Rob Received on Fri Jul 31 1998 - 11:25:47 CDT