Re: php-db Digest 23 Nov 2005 09:54:55 -0000 Issue 3170

--------------080301060503050700020308
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

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




--------------080301060503050700020308
Content-Type: text/plain; charset=us-ascii

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

Re: Re: php-db Digest 23 Nov 2005 09:54:55 -0000 Issue 3170

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

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

=2DMicah=20

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=3D6.
>
> 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

Re: Re: php-db Digest 23 Nov 2005 09:54:55 -0000 Issue 3170

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
>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