Re: [PHP] Storing images in MySQL bad idea, performance-wise?

2002-07-08 Thread Analysis & Solutions

On Mon, Jul 08, 2002 at 04:34:20PM -0600, René Fournier wrote:
> 
> Do I store all such images in the DB? (Which I understand reduces 
> performance.)

You can, but it's a pain and inefficient.


> 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.)

Images don't have to be served from one the page is on.  Use a fully 
qualified URI in the img src.

--Dan

-- 
   PHP classes that make web design easier
SQL Solution  |   Layout Solution   |  Form Solution
sqlsolution.info  | layoutsolution.info |  formsolution.info
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
 4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP] Storing images in MySQL bad idea, performance-wise?

2002-07-08 Thread René Fournier

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,
[EMAIL PROTECTED]

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


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php