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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
