MySQL Image Storage

[Jon T]

Hey Gang!

Wanting to know which is better / easier to work with. Uploading a file as a blob to MySQL and then process a thumb and larger image. Or Process the images first, and store the location of the images as a string, instead of the image as a blob.

Comments?

:thumbsup:

[raf]

This is just my personal preference, but it always store the filename (or filenames)

I think that reading and grabbing the blob's takes longer then just selecting the filenames. so it should be lighter on the db. Well, that's what i think ...

What is easier? If you upload the files through a form, you can write the fileadress to the db, so that's just as easy as storing the image in the db.

[Jon T]

Raf,

Do you use the full server path, or a root relative path? I am using ASPUpload and not sure if it supports a root relative upload.

[raf]

i always use relative path. cause i tend to port the apps frequently to other machines.

don't know about aspuload, but you can always change the value into the virtual path.

[Jon T]

You using a custom upload application? ( Something you have Written )

[raf]

no. just never uploaded :D when i was using asp. mostly using php now and there it's really just a function with a few lines of code.

[Jon T]

Nice, If I were using ASP.NET, I think it would be the same issue, just using a built in function...

:(


Stuck with ASP for now.

:)

Thanks for your help,

:thumbsup: