Re: Prepare Statement

From: Kris Jurka <books(at)ejurka(dot)com>
To: Jie Liang <jie(at)stbernard(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Prepare Statement
Date: 2004-06-18 21:47:01
Message-ID: Pine.BSO.4.56.0406181645280.21687@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-sql

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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-06-18 21:47:53 Re: Prepare Statement
Previous Message Kris Jurka 2004-06-18 18:49:16 Re: proposal for CallableStatements to handle multiple out

Browse pgsql-sql by date

  From Date Subject
Next Message Kris Jurka 2004-06-18 21:47:53 Re: Prepare Statement
Previous Message Jaime Casanova 2004-06-18 21:38:28 case stement when null