that sound verry logical. It seams that most of you are absolutly sure that saving images to the OS FS is way faster than to blob in mysql.
The main reason why I am trying to do so is because I would like to seperate my application from the content. Whenever I make an update of the application I have to move around files which are in a data folder inside the application. So I was searching for a way to avoid this and keep the data untouched. Maybe someone knows a better way to do that? Thanx for your help guys, Andy - Knud I thought this might be of interest for u 2 "Richard Lynch" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:20020701232018.VNIV6023.sccrmhc02.attbi.com@[192.168.1.103]... > >I do save images with 1 K and 4 KB to blob fields while I used to save them > >to file. It seams to me that this is much slower accessing the files. The > >images take a bit (really short but absolutly noticable) to show up on the > >site. Is there a way to improve the performance, and why is this happening? > > > The file system will almost certainly be *WAY* faster than MySQL. > (I'm sure somebody can come up with a two-tier system with burning fast > MySQL and dog-slow hard-drive on the HTTP server, but... let's be real > here...) > > If the images are "too slow" you need to look at your BANDWIDTH, the HTTP > server speed, and the hard drive speed, and the caching system of the OS. > > Moving the images into MySQL is unlikely to really solve any of these. > > You could run a quick test, though, in about 15 minutes of work, with a > single image, just to be sure. > > -- > Like Music? http://l-i-e.com/artists.htm Not really, the OS filesystem contains features that makes it always faster than a sql query, that will increase your network traffic too. Inserting images or whatever binary data in a database does not have much sense, you could not do a query with this field, cannot be indexed (dunno if exists a DB that implement a image indexer ;) ). Storing relative pathes gave me always more portabilities between DBM. In some case, you have to insert images (or every others binary data) in DB (due to global permissions system only avaible for the DB and not for the filesystem, for example), but as far is possible, I avoid to do it so. IMHO :) pa -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
