Recommendations - blob or file system

[Anon]

I am working on putting together a site that displays a dynamic list of images on a page, then you click each link and you get the image displayed on the next page.

I have it working right now (kind of) and I uploaded the images into the mySQL db as a blob. However, everyone else is saying i should have the image be stored on the file system, and reference the filename from the db in the image source. Is one way better then the other?

Jason

[greg252]

the mySQL manual states that to improve performance, DO NOT STORE IMAGES IN TABLES, store a reference to the file.

[Anon]

Greg,

Thanks a lot! I guess I did it the wrong way, doh! Back to the drawing tables.

Jason