Skip site navigation (1) Skip section navigation (2)

Re: Prepare Statement

From: "Jie Liang" <jie(at)stbernard(dot)com>
To: "Kris Jurka" <books(at)ejurka(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Prepare Statement
Date: 2004-06-21 16:28:38
Message-ID: E7E213858379814A9AE48CA6754F5ECB034519E6@mail01.stbernard.com (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-sql
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

pgsql-sql by date

Next:From: Phil EndecottDate: 2004-06-21 17:23:33
Subject: Re: plpgsql - Insert from a record variable?
Previous:From: Gary StainburnDate: 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 mory error.
Previous:From: Markus SchaberDate: 2004-06-21 16:20:05
Subject: Re: what is lslowing me down? JDBC or Postgresql itself?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group