Re: Storing images in MySql

From the mysql manual (http://www.mysql.com/doc/T/i/Tips.html): "When using a normal Web server setup, images should be stored as files. That is, store only a file reference in the database. The main reason for this is that a normal Web server is much better at caching files than database contents. So it it's much easier to get a fast system if you are using files." I guess Mysql developers are a good reference ;-) -- Julio Nobrega. Tô chegando: http://www.inerciasensorial.com.br "Mike Fifield" <Mike.Fifield@schwab.com> wrote in message news:FFE9B7BE532CD411872F00508BDFB8FE0EB76B9D@n6010vmx.nt.schwab.com... > After posting my question about performance earlier this morning it was > suggested that I also store the jpg's in the database, (thanks Maxim). I did > a little research and got a lot of conflicting information on weather this > is a good idea or not. For example the following url states that you suffer > a 30% performance hit by doing it this way. > http://www.zend.com/zend/trick/tricks-sept-2001.php > <http://www.zend.com/zend/trick/tricks-sept-2001.php> > Is anyone out there running a website that stores images as binary data in > MySql that could comment on this? > Any and all comments are welcome. > > Mike > > > >