Search Postgresql Archives

Re: How to store fixed size images?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 06/16/2014 08:10 PM, sunpeng wrote:
We have many small size(most fixed size) images, how to store them? There are two options:
1. Store images in folders, managed by os file system, only store path in postgresql
2. Store image as bytea in postgresql
How do you usually store images?
Thanks!

peng

I think it depends on how you are going to use them.  I, for example, have lots of images that are served on a web page, after benchmarks I found it was faster to store them on filesystem and let apache serve them directly.

-Andy



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux