Does plperl catch the plan also?
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
but not all procedural languages do.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
pgsql-sql by date
|Next:||From: Phil Endecott||Date: 2004-06-21 17:23:33|
|Subject: Re: plpgsql - Insert from a record variable? |
|Previous:||From: Gary Stainburn||Date: 2004-06-21 15:11:42|
|Subject: Re: subselect prob in view|
pgsql-jdbc by date
|Next:||From: Sailer, Denis (YBUSA-CDR)||Date: 2004-06-21 16:44:51|
|Subject: JDBC driver inserting into a table with Bytea type gets out of me
|Previous:||From: Markus Schaber||Date: 2004-06-21 16:20:05|
|Subject: Re: what is lslowing me down? JDBC or Postgresql itself?|