Juan Backson wrote:
Hi,
For this problem, what if I use prepared statement? if I use prepared
statement directly from libpq, would it help?
It will possibly change the way postgres plans the query, so you may get
a different execution time.
http://www.postgresql.org/docs/current/static/sq
Hi,
For this problem, what if I use prepared statement? if I use prepared
statement directly from libpq, would it help?
Thanks,
JB
On Mon, Aug 24, 2009 at 9:59 AM, Craig Ringer
wrote:
> On Mon, 2009-08-24 at 00:08 +0800, Juan Backson wrote:
>
> > I have a sql that only takes 0.3 ms to run when
On Mon, 2009-08-24 at 00:08 +0800, Juan Backson wrote:
> I have a sql that only takes 0.3 ms to run when using psql with
> "explain analyze".
"explain analyze" reports server-side execution time.
> However, when I execute it using PQexec, it takes 12ms for PGexec.
> Does anyone know why it is t
