I did do that for a galery-script of myself. I don't have any numbers if
you'r looking for that but my personal impression was, that the picture
output from the mysql-db is actually faster than reading directly from disk.
But that could be due to server capabilities of my ISP (if he has for
example a high tech mysql-server and a relativly slow machine for apache).

But with a quite fast mysql-server it shouldn't be a problem I think.

And if it _would_ be a problem, I think there are still more positive
aspects then negatives (easy handling, having stored all important
informations together, fast searching of images with keywords and so on)

best regards
Stefan Rusterholz, [EMAIL PROTECTED]
interaktion gmbh
Stefan Rusterholz
Zürichbergstrasse 17
8032 Zürich
T. +41 1 253 19 55
F. +41 1 253 19 56
W3 www.interaktion.ch
----- Original Message -----
From: "Jim Musil" <[EMAIL PROTECTED]>
Sent: Friday, November 30, 2001 4:47 PM
Subject: [PHP] Speed of Images from DB

> I've been searching for the best way to store images that would be
> used in a dynamic site. In this situation, a site admin would upload
> images via a php script. Obviously this creates several problems.
> To prevent naming problems, I have php name all the uploaded images
> and store the name in a mysql db. Then, when needed, php will query
> to get the name and insert the image name into the image tag. This
> has always seemed like an incomplete solution because it's hard to
> manage the files later.
> Using mySQL to do the whole thing is appealing. I've never tried
> storing the actual data in my mysql db. It seems like it would be too
> slow to query, transfer, and passthru.
> Does anyone have any wisdom on this subject?
> --
> Jim Musil
> ---------
> Multimedia Programmer
> Nettmedia
> -------------
> 212-629-0004

PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to