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

Re: [PERFORMANCE] Stored Procedures

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Marcos <mjs_ops(at)gmx(dot)net>
Subject: Re: [PERFORMANCE] Stored Procedures
Date: 2006-01-23 12:30:31
Message-ID: 43D4CC67.9050703@logix-tt.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hi, Marcos,

Marcos wrote:

> This one was my doubt, perhaps in based desktop applications this is
> true, but in web applications this is not the re-connecting is
> constant :(.

If this is true, then you have a much bigger performance problem than
query plan preparation.

You really should consider using a connection pool (most web application
servers provide pooling facilities) or some other means to keep the
connection between several http requests.

Worried,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

In response to

Responses

pgsql-performance by date

Next:From: MarcosDate: 2006-01-23 13:27:25
Subject: Re: [PERFORMANCE] Stored Procedures
Previous:From: Franklin HautDate: 2006-01-23 10:46:27
Subject: ENC: RES: pg_dump slow - Solution

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