The answer I would give at this moment would be a variant of your A)
version where the hash directories would further contain directories
limited to, say 300 images. Found it out after a painfully slow
experience with MySQL blobs. I did not however implement this solution
yet (still using the
Lots of good ideas.
One other thing to consider when designing this is the possibility of
multiple web server accessing a single database server.
If you use the file system method which assumes that the web/db are on the
same server as soon as you want to have multiple web servers you'll run
[snip]
Having a large number of files in a single directory does affect
performance,
the degree of which depends on the filesystem.
This is generally accepted wisdom for dealing with large numbers of files -
but what number is considered large?
Any rules of thumb, for different
3 matches
Mail list logo