Performance when storing images in database?

Soldato
Joined
12 Jun 2005
Posts
5,361
Basically I am creating an application in C#.NET with an access database (don't want the client to have to have sql server installed on their machine).

I am wondering whether it would be best to store images in a database or just store them in a folder with the filename just the ID of the record (which is fine either way).

The images will probably all be less than 100KB and most are likely to be less than 50KB. It is likely that there could be up to tens of thousands of records.

I am just wondering, from a performance point of view (reading the images & fields and displaying them on screen), which would be the better solution? (images in database or filesystem?).

I will be using the datareader object/class to read the data from the database.

Thanks.
 
Last edited:
Thanks for the replies guys.

I did read Sic's thread but thought that it might be aimed at people using MYSQL+PHP rather than a windows based access database+.net.

I will use a file system i think.

Cheers.
 
The data used is not likely to be backed up tbh...all the data and images could easily be recreated by clicking one button, although it may take about an hour to recreate the whole database + images, it is unlikely that any user intervention is needed.
 
Back
Top Bottom