What do you guys think it's better, store files in MySQL or physical folders?

I'm wondering wether to store files uploaded by users into MySQL or create on-the-fly folders for each user everytime they upload a file.
I guess it's better to store them into folders and not into MySQL but I don't know how convenient would be to use MySQL since I've never tryied to store files into it.
What it's your advise?

p.s.- users files won't be larger than 1024 or 2048 kilobytes.

[Free WordPress Themes]

Store very small files(some KB)  in a database (only if you need this) and forget it to two store bigger files

[Free WordPress Themes]

[offtopic] Eliezer, is your avatar about the TV serie "Pokemon" (it looks like)

hehe

[Join us @ facebook]

I agree that you should store files to the filesystem, except if you have a system that has really high traffic, so you need database to make the load faster (of course this would be true if you had a very fast DB server, otherwise it wouldn't really help)

To make this you will need to use commands like mkdir() and fopen.

haha, naw Olaf. it's also a Japanesse cartoon though, it was called SuperChampions in México. Captain Tsubasa in Japan, probably in USA too.
The guy in the avatar is Bruce Harper, mid-fielder that looks like me (because of the crew cut haha).

I think I'll store the files in folders but right now I'm too tired to do the coding. I've been on the computer since monday and only got out to play some soccer and smoke a little with my friends.
I'll get some sleep for now and tomorrow I'll try to  do this coding to upload files.
Peace man, see ya in a few hours.

[Free WordPress Themes]

haha, naw Olaf. it's also a Japanesse cartoon though, it was called SuperChampions in México. Captain Tsubasa in Japan, probably in USA too.
The guy in the avatar is Bruce Harper, mid-fielder that looks like me (because of the crew cut haha).

I think I'll store the files in folders but right now I'm too tired to do the coding. I've been on the computer since monday and only got out to play some soccer and smoke a little with my friends.
I'll get some sleep for now and tomorrow I'll try to  do this coding to upload files.
Peace man, see ya in a few hours.

if you store images in a database you need to upload the data too

I think they show the cartoons here too (it's about some futuristic football play right?)

Well, there are like 2 or 3 'versions' of Captain Tsubasa. I don't really know if one it's futuristic but yeah, it's about Soccer. It was such a big thing back in 1994 because of the USA World Cup and everything, you know. I live at 2 hours from Texas and when you had the World Cup we were also affected in a good way. So TV started showing this cartoon at the same time than the World Cup and it was a big success.

[Guest]

[36.294]

Googlebot, Yahoo crawler, Msnbot, Baidu Spider, classylady