Received: from p1.selectacast.net (IDENT:root@p1.selectacast.net [206.41.1.251]) by hub.org (8.10.1/8.10.1) with ESMTP id e6OJvjh87363 for ; Mon, 24 Jul 2000 15:57:45 -0400 (EDT) Received: from selectacast.net (IDENT:jks@d1 [209.219.91.66]) by p1.selectacast.net (8.9.3/8.9.3) with ESMTP id PAA24265; Mon, 24 Jul 2000 15:57:35 -0400 Message-ID: <397C9FAE.149DFB40@selectacast.net> Date: Mon, 24 Jul 2000 15:57:34 -0400 From: Joseph Shraibman Organization: Xtenit X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.15 i686) X-Accept-Language: en MIME-Version: 1.0 To: Peter Mount CC: george stewart , Interfaces Subject: Re: Anyway in JDBC to dectect if DB supports pre-compilation References: <20000723215245.17935.qmail@web1502.mail.yahoo.com> <023101bff580$d5675040$512629d4@retep.org.uk> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200007/176 Isn't creating a function the same as precompiling? Peter Mount wrote: > > No. as the backend doesn't currently supports it. As soon as it does, it > will do. > > PreparedStatement is currently handled purely by the JDBC driver. As soon as > "pre-compilation" is supported, then the performance improvement would be > immense. > > Peter > > -- > Peter T Mount peter@retep.org.uk, peter@retepdigital.com, me@petermount.com > Homepage: http://www.retep.org.uk Contact details @ http://petermount.com > PostgreSQL JDBC: http://www.retep.org.uk/postgres/ > Java PDF generator: http://www.retep.org.uk/pdf/ > > ----- Original Message ----- > From: george stewart > To: Interfaces > Sent: Sunday, July 23, 2000 10:52 PM > Subject: [INTERFACES] Anyway in JDBC to dectect if DB supports > pre-compilation > > Sorry for slightly off-topic, but is there some way in > JDBC to detect if the connection supports > pre-compilation of prepared statements. > > Regards, george > > __________________________________________________ > Do You Yahoo!? > Get Yahoo! Mail - Free email you can access from anywhere! > http://mail.yahoo.com/