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
Hi,
I have a sql that only takes 0.3 ms to run when using psql with "explain
analyze".
However, when I execute it using PQexec, it takes 12ms for PGexec. Does
anyone know why it is that slow?
My db server is in the internal network, so there should not be any latency
issue.
Any suggestion will
