Pictures in MySQL database ?
 

I heard it wasn't really reliable ?

What are your thoughts on the subject ?

Just store the location of the image in your db.

Nah I need to have quick access to the files since I'll have to process thousand of them.

Sounds like you've already made up your mind... but if your gonna do it then store them in a seperate table on their own.

I'm considering storing them on a FTP too. Whould be cleaner in DB...

Why should I store them in a separate table ? (sounds like a good idea though)

Your database will grow very quickly, but its very reliable if you store them correctly as a BLOB. I tested speed on requesting images in a mysql db vs images stored on server and there was not much difference in speed.

You want to store the DATA of an image in a MySQL database?

Why?!

Store it on disk and store the location of it in a table.

Efficiency. I will have to process 100'000's of picture every day.

I'm just wondering how storing it in a DB rather than a reference to it in a DB makes it easier for you? (not trying to be sarcastic, I'm geniunely curious)

There are benefits in doing that. Especially if you need a true DDB.

it's very possible, I've done it on a few of my sites.
Just stick it in the blob structure, and use php's great tmp_file procedure!

Never ever use MySQL for storing pics any database expert will tell you this
it affects performance greatly especially if you need mysql for other things besides a pic server

On one site, I use X-cart as a shopping cart ( about 300 products ). The default option is to store the images in the DB...
Tried both and it was more reliable and a tandy faster with images in DB. :2 cents: