From: | "Randolf Richardson, DevNet SysOp 29" <rr(at)8x(dot)ca> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Picture with Postgres and Delphi |
Date: | 2003-11-19 07:08:19 |
Message-ID: | Xns9437E95D0EFE2rr8xca@200.46.204.72 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)8x(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Randolf Richardson, DevNet SysOp 29 | 2003-11-19 07:11:28 | Re: Oracle and regular expressions ??? |
Previous Message | Randolf Richardson, DevNet SysOp 29 | 2003-11-19 07:03:37 | Re: Good open source mailing list system PHP / Postgresql |