Re: Picture with Postgres and Delphi - Mailing list pgsql-general

From Randolf Richardson, DevNet SysOp 29
Subject Re: Picture with Postgres and Delphi
Date
Msg-id Xns9437E95D0EFE2rr8xca@200.46.204.72
Whole thread Raw
In response to Picture with Postgres and Delphi  ("Edwin Quijada" <listas_quijada@hotmail.com>)
Responses Re: Picture with Postgres and Delphi
List pgsql-general
>> There is no need for manually storing files on filesystem, because
>> large objects are doing that for You. I am storing whole binary files
>> in blobs(synonym for large objects from some other platforms), and I do
>> not remember that I had a single problem with that. Do not forget that
>> libpq has great support for large objects, and you can store large
>> object without actually storing them on server filesystem, so You do
>> not need any file permissions on "upload directory" or something like
>> that.
>
>    The pictures are prepared for web. Storing in files is faster from
> that side. That system is calling db every 30 mins...
[sNip]

        Has anyone done any benchmarks on this to know what the performance
differences are for downloads (I'm not concerned about uploads since they're
far less frequent) from a web server such as Apache HTTPd accessing the file
system directly vs. a CGI script/program sending it dynamically through
Apache HTTPd?

--
Randolf Richardson - rr@8x.ca
Inter-Corporate Computer & Network Services, Inc.
Vancouver, British Columbia, Canada
http://www.8x.ca/

This message originated from within a secure, reliable,
high-performance network ... a Novell NetWare network.


pgsql-general by date:

Previous
From: "Randolf Richardson, DevNet SysOp 29"
Date:
Subject: Re: CASE tools
Next
From: Lynn.Tilby@asu.edu
Date:
Subject: Re: Better Unilization of Memory