Re: Speed of Images from DB

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, s.rusterholz@interaktion.ch ---------------------------------- 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" <jim@nettmedia.com> To: <php-general@lists.php.net> 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 > jim@nettmedia.com