Re: [PERFORMANCE] Stored Procedures - Mailing list pgsql-performance

From Markus Schaber
Subject Re: [PERFORMANCE] Stored Procedures
Date
Msg-id 43D4CC67.9050703@logix-tt.com
Whole thread Raw
In response to Re: [PERFORMANCE] Stored Procedures  (Marcos <mjs_ops@gmx.net>)
Responses Re: [PERFORMANCE] Stored Procedures  (Marcos <mjs_ops@gmx.net>)
List 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

pgsql-performance by date:

Previous
From: Alessandro Baretta
Date:
Subject: Re: Suspending SELECTs
Next
From: Marcos
Date:
Subject: Re: [PERFORMANCE] Stored Procedures