PQexecParams performance - Mailing list pgsql-bugs

From Harry Rossignol
Subject PQexecParams performance
Date
Msg-id 001901c5ff48$c5862c00$a6dbfea9@harryvi
Whole thread Raw
Responses Re: PQexecParams performance
List pgsql-bugs
My experience using PQexecParams is that it has a performance
degradation of a factor of 100's if not thousands.
I have reworked my queries to DECLARE a binary cursor for the return
results and using a fixed text statement for the PQexec select.
It doesn't help on Inserts and Updates but it sure helps on straight
select statement queries.

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #2108: Function with OUT parameters not recognized, using plpgsql
Next
From: Tom Lane
Date:
Subject: Re: PQexecParams performance