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" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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
>
>
>
>



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to