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 <micah@xxxxxxxxxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: Re: 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
