Re: [PHP] Re: [PHP-DB] blob versus file

2002-07-02 Thread Richard Lynch
>the blob field can't be indexed but others (id, filename, keywords, >caption etc..) can, there's lots of cases where it makes sense to put >images in a database. This makes no sense to me. You would still index the filename, the keywords, the caption, make them all searchable, but you do *NOT*

Re: [PHP] Re: [PHP-DB] blob versus file

2002-07-01 Thread Andy
i also noticed that the images are not cached at all. The other images comming from the FS are cached just fine. Do u think thats because of the blob? Andy "Mark" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... On Mon, 1 Jul 2002 14:20:30 +0200, Pierre-Al

Re: [PHP] Re: [PHP-DB] blob versus file

2002-07-01 Thread Mark
On Mon, 1 Jul 2002 14:20:30 +0200, Pierre-Alain Joye wrote: >On Mon, 1 Jul 2002 14:17:53 +0200 >"andy" <[EMAIL PROTECTED]> wrote: > >>Hi there, >> >>I am wondering if anybody has experiance in saving images to blob >>in mysql. >> >>I do save images with 1 K and 4 KB to blob fields while I used to

Re: [PHP] Re: [PHP-DB] blob versus file

2002-07-01 Thread Pierre-Alain Joye
On Mon, 1 Jul 2002 11:24:31 -0700 "Lazor, Ed" <[EMAIL PROTECTED]> wrote: > Aren't you saying that storing files on the local file system is generally > faster than using database blobs? In most cases I meet (mysql, pgsql and oracle), the filesystem methods were faster on Linux and Solaris syst

RE: [PHP] Re: [PHP-DB] blob versus file

2002-07-01 Thread Lazor, Ed
Aren't you saying that storing files on the local file system is generally faster than using database blobs? There are enough examples in the article and related threads to convince me that benefits to database blobs are more than exceptions to the rule. In fact, there are even examples where d

Re: [PHP] Re: [PHP-DB] blob versus file

2002-07-01 Thread Pierre-Alain Joye
On Mon, 1 Jul 2002 09:35:37 -0700 "Lazor, Ed" <[EMAIL PROTECTED]> wrote: > There are benefits to this making the performance hit worthwhile in some > instances. Sure, the exceptions rules :). I am not sure about your answer. The article where you pointed me does not go against what we said, a

RE: [PHP] Re: [PHP-DB] blob versus file

2002-07-01 Thread Lazor, Ed
There are benefits to this making the performance hit worthwhile in some instances. More info: http://www.zend.com/zend/trick/tricks-sept-2001.php -Original Message- Inserting images or whatever binary data in a database does not have much sense **