AspUpload - File System or DB ?

[sivvaa]

Hi all,

Couple of Queries :

1. Iam using AspUpload with AspJpeg to create thumbnails and Image Uploading. Now, which one is advicable :

whether to store the images in FOLDER ?

or

Store the Images in the DB as binary code.

If we store the images as BINARY, will the DB size increase ?

Is there anyother component suggested for this ?

Thanks

Siv

[Silverbug]

Personally I would save the images to a folder. that way when retreving files its less overhead getting them to the browser, i would also think it would be a tad quicker as files too. Also depending on how your software works you may not be reliant on the db server, which would be bad if the server went down.

[DigitalSkyline]

I'd personally advocate using the file system over using the database (also)... and yes because it would dramatically increase the size of the database.

The only problem is that depending on what you are doing it is more complicated to track the file and update/delete using the FS.

Say you are setting up a forum which allows custom avatars... users upload avatars...
you store the file in ./images/users/

In the database you have the image location stored.

Now when you delete that user (or database row), you also have to delete the file.

Not a big deal, really... but just deleting the row would probably be "easier"

Backing up just the database might also be "easier" then backing up the DB and the images folder.

Still, the performance is the top priorty IMO. Databases are best for data that needs to be indexed... not really intended for storing binary data.

[Brangwyn]

It's normally recommended not to store binary objects in a database, particularly jpegs, it's a resource issue really, why put the database to work serving binary data that could and should really just be served straight from the web servers HDD.

[sivvaa]

Ok..Now that I have chosen to store the images in a FOLDER rather than binary data..

When I delete a Record, it gets deleted from the TABLE ROW and it Only removes the Path of the image. How to remove the IMAGE itself from the folder at one go...

any solution >?

[DigitalSkyline]

http://www.w3schools.com/asp/asp_ref_filesystem.asp

See delete file...