Re: Writing most code in Stored Procedures

From: Guy Rouillier <guyr-ml1(at)burntmail(dot)com>
To: PgSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: Writing most code in Stored Procedures
Date: 2007-08-18 05:37:33
Message-ID: 46C6859D.4060506@burntmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Steve Manes wrote:
> Moving all the application-bound inserts into stored procedures didn't
> achieve nearly the performance enhancement I'd assumed I'd get, which I
> figured was due to the overhead of the procs themselves.

That's the conclusion I'm coming to as well for my app with very high
insert/update rates. Is there a PG knowledgebase where this kind of
information might be useful?

--
Guy Rouillier

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrej Ricnik-Bay 2007-08-18 05:42:53 Re: I get a error msg when i try to connect to the DB
Previous Message novice 2007-08-18 05:35:12 Join query help