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

Re: Is this usage correct ?

From: Arkin <arkin(at)exoffice(dot)com>
To: Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk>
Cc: "'Guillaume Rousse'" <Guillaume(dot)Rousse(at)univ-reunion(dot)fr>, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Is this usage correct ?
Date: 2000-04-19 20:11:02
Message-ID: 38FE12D6.B4274285@exoffice.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
Most RDBMS support two modes of queries. Statements and prepared
statements.

Statements are SQL strings that are parsed and processed in one go.
Prepared statements are pre-prepared and can be reused any number of
times. Since parameters tend to change across method invocation, they
support bound parameters (the '?' thingy).

In terms of performance statements are slightly faster if used only once
(Oracle 7) and prepared statements are way faster if used twice or more
times (Oracle 7 again). The RDMBS will construct a query plan during
preperation and only once for a given statement, thus saving a
non-marginal cost (especially if the query is rather complex). In fact,
in some instances where the results of a query are less than 100 records
(w/o long binary/char fields), using prepared statement can achive an
80% performance improvement.

arkin



Peter Mount wrote:
> 
> In theory it would be ok, but as PreparedStatement extends Statement,
> why cause the extra overhead and just use Statement?
> 
> Peter
> 
> --
> Peter Mount
> Enterprise Support
> Maidstone Borough Council
> Any views stated are my own, and not those of Maidstone Borough Council.
> 
> -----Original Message-----
> From: Guillaume Rousse [mailto:Guillaume(dot)Rousse(at)univ-reunion(dot)fr]
> Sent: Wednesday, April 19, 2000 10:47 AM
> To: pgsql-interfaces(at)postgresql(dot)org
> Subject: [INTERFACES] Is this usage correct ?
> 
> Is it correct to use a preparedStatement with no variable element, as
> this:
> PreparedStatement stmp=conn.prepareStatement("delete from table where
> oid="+oid);
> stmt.excuteUpdate();
> 
> Or is it mandatory to use :
> PreparedStatement stmp=conn.prepareStatement("delete from table where
> oid=?");
> stmt.setInt(1,oid);
> stmt.excuteUpdate();
> 
>  --
> Guillaume Rousse
> Iremia - Université de la Réunion
> 
> Sleep doesn't exists. Just lack of cafeine.

-- 
----------------------------------------------------------------------
Assaf Arkin                                           www.exoffice.com
CTO, Exoffice Technologies, Inc.                        www.exolab.org

In response to

pgsql-interfaces by date

Next:From: ganesanmDate: 2000-04-19 21:18:01
Subject: How do I select nth row from a table
Previous:From: Tibor LaszloDate: 2000-04-19 18:47:33
Subject: Re: ODBC not reporting RI violations.

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