|
|
Posted by seaside on 12/22/06 03:57
eholz1 schrieb:
> Hello Members,
>
> I am setting up a photo website. I have decided to use PHP and MySQL.
> I can load jpeg files into the table (medium blob, or even longtext)
> and get the image(s) to display without a problem.
Just a small performance note:
If you use blobs and various other types, MySQL is likely to fall back
in table-scan mode which might slow down your queries very much. A
table-scan needs to read the full table data, at least much more, than
an index.
Even if you use some indexes, MySQL might not use them - the exact
behaviour depends on your indexes and queries.
Are there good reasons to keep image data in tables and not in file
systems - other than simpler coding, e.g.?
Navigation:
[Reply to this message]
|