Обсуждение: 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/
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 <georgestewartiv@yahoo.com> To: Interfaces <pgsql-interfaces@postgresql.org> 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/
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 <georgestewartiv@yahoo.com> > To: Interfaces <pgsql-interfaces@postgresql.org> > 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/