Home  |  Linux  | Mysql  | PHP  | XML
From:Patrick Price Date:Wed Feb  3 13:20:32 2010
Subject:Re: Storing images
I would say that only if this is going to be a very small project should you
think about storing the images in the db.  I had a contract job for a real
estate company that had stored all their images in the database.  They had
~25K rows of data where each image was ~5K and their website was going down
weekly.

I had to rewrite the entire image upload/retrieval system for their site to
change it to folder based storage.

Just my thoughts...

Thanks

patrick



On Wed, Feb 3, 2010 at 8:02 AM, Phpster <phpster@gmail.com> wrote:

> Sure is.  Save the data in a blob field. Lots of examples on the net on how
> to get it there and back out again.
>
> Note that you will also find arguments about whether or not to do it in the
> first place. I prefer not to, as it causes significant performance issues
> when the image table gets to a certain size.
>
> Bastien
>
> Sent from my iPod
>
>
> On Feb 3, 2010, at 2:37 AM, Karl DeSaulniers <karl@designdrumm.com> wrote:
>
>  Hello List,
>> Forgive me if this is a noob question, but is it possible to fill a
>> database table with actual image data, IE a jpeg? And then call that data to
>> display the image?
>> Or is it better to just reference it stored on the server somewhere and
>> just put the url in the database?
>> Thanks,
>>
>> Karl DeSaulniers
>> Design Drumm
>> http://designdrumm.com
>>
>>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

Navigate in group php.db at sever news.php.net
Previous Next


Your recent visits
Re: Hace frio..
piddle in hash
Re: piddle in hash
PRINT statements in SQL and SQLDataReader
Re: [PHP] 64 Bit IIS 6 ( 32 Bit mode ) + 32Bit php connect with MS-SQL Server


  
© No Copyright
You are free to use Anything
Site Maintained by Zareef Ahmed
Powered By PHP Consultants