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