Re: Prepare Statement

Does plperl catch the plan also?

Thanks.

Jie Liang

-----Original Message-----
From: Kris Jurka [mailto:books(at)ejurka(dot)com]
Sent: Friday, June 18, 2004 2:47 PM
To: Jie Liang
Cc: pgsql-sql(at)postgresql(dot)org; pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Prepare Statement

On Fri, 18 Jun 2004, Jie Liang wrote:

> However, I am still thinking if I call one SELECT and one DELECT and
> one UPDATE and one INSERT a thousand times against same table with
> different arguments, should I consider performance iusse?

Right, this is a case where some benefits can be found, but remember the

premature optimization adage.

>
> Secondly, I assume the function should be a pre-compiled object stored

> on server side, doesn't it.
>

I depends on the language the function is written. plpgsql caches
plans,
but not all procedural languages do.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html