Storing images in MySQL bad idea, performance-wise?
| From: | René Fournier | Date: | Mon, 08 Jul 2002 22:34:20 +0000 |
| Subject: | Storing images in MySQL bad idea, performance-wise? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-106192@lists.php.net to get a copy of this message | ||
I'm working on a simple content management system that uses PHP and MySQL for updating a web site's text (stored in a MySQL database). (The PHP scripts that do the updating (my stuf) live on one web server, the actual DB data to be updated (my client's stuff) live on another.) So far, I've only had to he able to update the text content of a site--therefore, I've only had to bother to store textual data in the client's DB. But now the client wants to be able to upload/change/delete certain pictures on their web site--using my CMS tool--so I am faced with the following problem:
Do I store all such images in the DB? (Which I understand reduces performance.)
Or do I--somehow--store the images as files on the client's web server? And if so, how? (Because my PHP scripts are being executed on a different server.)
...Rene
---
René Fournier,
rene@smartslitters.com
Toll-free +1.888.886.2754
Tel +1.403.291.3601
Fax +1.403.250.5228
www.smartslitters.com
SmartSlitters International
#33, 1339 - 40th Ave NE
Calgary AB T2E 8N6
Canada