MySQL + ASPJpeg + BLOBS

[candelbc]

I am trying to decide between two options. I am working on a ASP Application that allows the user to upload a picture.

What would be better...

1.) Save the picture in a specific directy, and a link to the picture in the database

2.) Store the picture as a blob and access it from the database..


I would LOVE to hear the pros and cons for each..

-Brad

[phpnovice]

It is a very bad idea to use a database for that which the File System is better suited. A database is well designed for handling data -- not files. Database bloat is one of the things that slows database access down. You exponentially increase database bloat by storing entire files in it.