|
|
Posted by Mary Pegg on 03/28/07 15:27
Jerry Stuckle wrote:
> Sure, it works fine. As I said, I've done it a lot of times. And yes,
> there are some really good reasons for keeping it in a database.
Such as?
> You need to design carefully to have good response, however. Generally
> I've found it helps to keep the image/scanned doc/whatever in a separate
> table consisting only of the id, the blob and what you will need only
> when you display it (i.e. for an image you might want the size). Other
> things like a description, etc. keep in its own table. This keeps the
> load down on the server and makes for faster response.
Or you could go one better, and store the blob in a separate "database".
One accessed with "readfile()".
> But this is still off topic in a PHP newsgroup. A database newsgroup
> would be better.
Welcome to the wonderful world of cross-posting.
--
"Checking identity papers is a complete waste of time. If anyone can
be counted on to have valid papers, it will be the terrorists".
Navigation:
[Reply to this message]
|