I know that we've moved to the filesystem, since we are running into trouble with large db with images. Oneof our clients had about 12gb of image / blob data and it caused a few problems. After yanking out the image / blob data, we reduced the Db to about 1gb and gained tons in performance.

Filesystem is best if there is a lot of activity regarding images and files...


Bastien


From: Micah Stevens <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Re: php-db Digest 23 Nov 2005 09:54:55 -0000 Issue 3170
Date: Thu, 24 Nov 2005 07:31:49 -0800


Use the database for what it was designed for, storing data that needs to be
parsed, and use the filesystem for what it was designed for, storing files.

Just my opinion, but I think it's a good one. :)

-Micah

On Thursday 17 November 2005 1:19 am, Marco Schierhorn wrote:
> Hey,
>
> we´ve large amount of Images ( nearly 2 GB ).
> And they will increase, cause or Editors will submit several articles a
> day where they´re allowed to upload
> some new pics.
> So, whats the better solution ? To store them in the filesystem ( with
> only the path in the db )
> or to store them as BLOB´s in the DB ( MySQL ).
> When we decide to store them in the DB, we´ve thought about splitting
> larger Images ( > 64 K ) into several pieces into the db.
> So, we´ve a simulated "streaming". I´ve seen it at
> http://php.dreamwerx.net/forums/viewtopic.php?t=6.
>
> So, any recommendation is very welcome.I would really appreciate any of
> them.
>
> Cheers
>
> Marco

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


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

Reply via email to