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

PQexecParams performance

From: "Harry Rossignol" <harrywr2(at)comcast(dot)net>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: PQexecParams performance
Date: 2005-12-12 18:20:45
Message-ID: 001901c5ff48$c5862c00$a6dbfea9@harryvi (view raw, whole thread or download thread mbox)
Lists: 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

Next:From: Tom LaneDate: 2005-12-12 22:56:10
Subject: Re: PQexecParams performance
Previous:From: Tony SDate: 2005-12-12 16:18:53
Subject: Re: BUG #2108: Function with OUT parameters not recognized,

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