Skip site navigation (1) Skip section navigation (2)

Re: [PERFORMANCE] Stored Procedures

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Rikard Pavelic <rikard(dot)pavelic(at)zg(dot)htnet(dot)hr>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORMANCE] Stored Procedures
Date: 2006-01-20 21:34:55
Message-ID: 20060120213455.GT20182@pervasive.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Fri, Jan 20, 2006 at 08:38:23PM +0100, Rikard Pavelic wrote:
> This would solve problems with prepare which is per session, so for 
> prepared function to be
> optimal one must use same connection.

If you're dealing with something that's performance critical you're not
going to be constantly re-connecting anyway, so I don't see what the
issue is.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby(at)pervasive(dot)com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

In response to

Responses

pgsql-performance by date

Next:From: Martijn van OosterhoutDate: 2006-01-20 21:37:54
Subject: Re: [GENERAL] Creation of tsearch2 index is very slow
Previous:From: Tom LaneDate: 2006-01-20 21:19:15
Subject: Re: [GENERAL] Creation of tsearch2 index is very slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group