Storing Image in Database

**jaimalchohan** · 22nd December 2005, 10:37 AM

Normally I would say don't do it, but this is a slightly different senario

The images are going to be uploaded by people who register (4 images per registration, ~10-20 registration per day), but also, every other day the images, toether with the rest of the registration info, will be be downloaded onto desktop by the client, the table will be imported into access (on his PC) and the SQL Db table online will be cleared.

It would be easier to store the image in the database right, expect that the image will vary in size, from 1-4 mb each., which chews up time to process.

So database or filesystem?

**Staff: Warren Ashcroft** · 22nd December 2005, 10:41 AM

FileSystem

Providing its all being stored/dispayed in a web app - if the image then gets shown in a desktop app, I would use database.

**jaimalchohan** · 22nd December 2005, 10:46 AM

Originally Posted by Warren Ashcroft

FileSystem

Providing its all being stored/dispayed in a web app - if the image then gets shown in a desktop app, I would use database.

Nah, once its uploaded by the member, the info desn;t get shown again online, its straight to desktop. Thanks!

**Staff: Warren Ashcroft** · 22nd December 2005, 11:19 AM

Originally Posted by jaimalchohan

Nah, once its uploaded by the member, the info desn;t get shown again online, its straight to desktop. Thanks!

Oh right, just noticed you had said this in the first post...

If its all desktop, database would be fine, however data download times would be a little lengthy.