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
|Next:||From: Tom Lane||Date: 2005-12-12 22:56:10|
|Subject: Re: PQexecParams performance |
|Previous:||From: Tony S||Date: 2005-12-12 16:18:53|
|Subject: Re: BUG #2108: Function with OUT parameters not recognized,|