From: Alexey V. Meledin <avm@webclub.ru>
To: Nicolas Huillard <nhuillard@ghs.fr>
To: pgsql-interfaces@postgresql.org
Subject: Re[2]: [INTERFACES] Sharing Database Connection Among Different CGI scripts writen in different languages
Date: Tue, 22 Feb 2000 14:27:57 +0300
Message-ID: <15602.000222@webclub.ru> (raw)
In-Reply-To: <01BF7D29.6DD3EE40@agen.int.ghs>
References: <01BF7D29.6DD3EE40@agen.int.ghs>
Hi,
Nicolas!
Tuesday, February 22, 2000, 1:39:06 PM, you wrote:
NH> I use Mason for this kind of stuff (www.masonhq.com). Quoting the site :
NH> "Mason is a powerful Perl-based web site development and delivery engine. With Mason you can embed Perl code in your HTML and construct pages from shared, reusable components. "
NH> For your problem, there are many solutions using Mason. The one I use is persistent DB connections, tied to the Apache servers.
NH> There are many benefit of this architecture : components (your scripts) are compiled only once and cached as long as the Apache process lives (no fork, exec, etc). The database connection are not
NH> only persistent in a whole page request, but also for all pages served by an Apache process.
NH> I think you can have a x100 performance improvement between your independent CGI design and this one (not laughing).
NH> Nicolas Huillard
Thanks for answer, but we doesn't use Perl for this. We use C/C++,
PHP, JSP (in future). Many programs are writen in this languages. It's
hard to transfer all to Perl. It's simple to make minor changes in
each script, that uses PostgreSQL.
Idea of Mason is good. But there is a little problem: We haven't our
own Server at ISP. We have only virtual hosting and possibilities they
provide to us.
Some people say that some databases (ORACLE and InterBase) provide
special database connection handlers that I can pass through my
non-concurrent scripts.
Does PostgreSQL has anything like this?
Regards, Alexey V. Meledin
InterForge Developers Group, Saint-Petersburg
look_to: <www.etcompany.ru><www.businessweb.ru>
<www.inplan.spb.ru><www.pia.ru>>>>>>>>>>>>>>>>>
mail_to: <avm@webclub.ru><nick_as: <cureman>>>>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: avm@webclub.ru, nhuillard@ghs.fr
Subject: Re: Re[2]: [INTERFACES] Sharing Database Connection Among Different CGI scripts writen in different languages
In-Reply-To: <15602.000222@webclub.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox