|
Posted by Christoph Burschka on 06/13/07 11:41
Jerry Stuckle schrieb:
> Databases work well with huge numbers of images - they're made to handle
> large numbers of rows. File systems aren't. 100K rows to a database is
> nothing. But try to put that many files in one directory.
>
Databases are meant to store huge *numbers* of records that can be
quickly indexed and searched. They're not meant to store big blobs of
binary data.
So use the appropriate tool for *each* part of the job.
Nearly every good CMS that handles images will use a folder in the file
system combined with a MySQL table of file names. There is no practical
limit to the number of files in a file system; the only performance
issue you get is when you try to list all of them at once or search for
one.
But give it a specific path (which MySQL found in its table in an
instant) and the file system will find your file immediately, regardless
of how many other files there are in the directory.
--
cb
Navigation:
[Reply to this message]
|