Blobbing images or file structure

[cinq]

Which would be a better means to storing images ?
And why ?

Inputs required

[Zachery]

Originally Posted by cinq

Which would be a better means to storing images ?
And why ?

Inputs required

im totaly confused by this :\

[Dean C]

He means is it better to store images in the database as a blob or as a file in a directory. Personally I prefer using directories as working with files in PHP is pretty easy

[Dominus]

database + mysql4 = your best friend

Storing files in DIR, I found it hard to find anything when you have alot of files(as categorizing/linking+mysql backend), also for backup, you can just dump mysql and your done, you dont have to download your whole data structure to make a backup.

[cinq]

Originally Posted by Mist

He means is it better to store images in the database as a blob or as a file in a directory. Personally I prefer using directories as working with files in PHP is pretty easy

Thanks for the clarification Mist, and the input.
Thanks too to Dominus for his/her input.

One issue:
Will the SQL end be 'slower' if i blob the data ?

[Brad]

Originally Posted by cinq

Thanks for the clarification Mist, and the input.
Thanks too to Dominus for his/her input.

One issue:
Will the SQL end be 'slower' if i blob the data ?

SQL will most likely be the same on speed depending on how you are pulling the results. Keep in mind that the table the images are stored in can grow large and might hurt you later on if you do not have telnet or other means of backing up the database without a php or some other kind of script that can timeout.