Small files: better in mysql or as a separate file?

49 views Asked by At

I have a website with a lot of small images (no larger than 300 kb). They're all in a single folder, and now they're around 40.000, but they keep increasing very fast. When I open a page of my website, each page will load 6 of those images. I can have also 1000 or more people connected together on my website.

Do you think this way of storing small files will slow down performances of my server? I thought about these possible solutions, but I'm not sure which of those is the best: - Store these pictures in folders, maybe a folder for each day, so we'll have no more than 5000 picture in each folder; - Store pictures in my DB in blob fields.

My server uses CentOS 6.5 as operating system.

Which solution do you think will be the best?

0

There are 0 answers