Re: Storing images in MySql
| From: | Richard Archer | Date: | Tue, 16 Apr 2002 21:10:56 +0000 |
| Subject: | Re: Storing images in MySql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-93258@lists.php.net to get a copy of this message | ||
At 12:48 PM -0700 16/4/02, Fifield, Mike wrote:
>Is anyone out there running a website that stores images as binary data in
>MySql that could comment on this?
I only store the images in the database when there is an admin
interface which allows new images to be uploaded.
If these images were stored in the file system, their directory
would need to be world-writable.
Instead I store them in a database requiring the upload script to
know the username/password.
I've never done this with a site which handles millions of hits.
I imagine there is a steep performance hit when the images are
being accessed a lot.
Caching would be the solution to that.
...R.