List:General Discussion« Previous MessageNext Message »
From:SmellySocks Date:November 24 2005 6:14pm
Subject:Re: Image Storage -- Better to store them on the Filesystem or in the
MySQL DB
View as plain text  
Hi Marco!

I had a similar problem and was advised that the native filesystem is faster 
than doing lookups and some sort of rendering.  So storing the link in the 
db will do it, and then just have the images at the pointed-to location.

Cheers!

-Warren


----- Original Message ----- 
From: "ESV Media GmbH" <mysql_list@stripped>
To: <mysql@stripped>
Sent: Thursday, November 17, 2005 1:18 AM
Subject: Image Storage -- Better to store them on the Filesystem or in the 
MySQL DB


> 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.
> 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
>
>
>
> <http://dict.leo.org/se?lp=ende&p=/Mn4k.&search=increase>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 

Thread
Image Storage -- Better to store them on the Filesystem or in theMySQL DBESV Media GmbH24 Nov
  • Re: Image Storage -- Better to store them on the Filesystem or in theMySQL DBSmellySocks24 Nov
  • Re: Image Storage -- Better to store them on the Filesystem or in the MySQL DBGleb Paharenko24 Nov