Re: [PERFORM] Prepared statement not using index

2005-09-12 Thread Dave Cramer
The difference between the 7.4 driver and the 8.0.3 driver is the 8.0.3 driver is using server side prepared statements and binding the parameter to the type in setXXX(n,val). The 7.4 driver just replaces the ? with the value and doesn't use server side prepared statements. Dave On

Re: [PERFORM] Prepared statement not using index

2005-09-12 Thread Guido Neitzer
On 12.09.2005, at 14:38 Uhr, Dave Cramer wrote: The difference between the 7.4 driver and the 8.0.3 driver is the 8.0.3 driver is using server side prepared statements and binding the parameter to the type in setXXX(n,val). Would be a good idea when this were configurable. I found my

Re: [PERFORM] Prepared statement not using index

2005-09-12 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The difference between the 7.4 driver and the 8.0.3 driver is the 8.0.3 driver is using server side prepared statements and binding the parameter to the type in setXXX(n,val). The 7.4 driver just replaces the ? with the value and doesn't use

Re: [PERFORM] Prepared statement not using index

2005-09-12 Thread Dave Cramer
On 12-Sep-05, at 9:22 AM, Guido Neitzer wrote: On 12.09.2005, at 14:38 Uhr, Dave Cramer wrote: The difference between the 7.4 driver and the 8.0.3 driver is the 8.0.3 driver is using server side prepared statements and binding the parameter to the type in setXXX(n,val). Would be a

Re: [PERFORM] Prepared statement not using index

2005-09-12 Thread Dave Cramer
It's added, just use the old protocol . Here are the connection parameters http://jdbc.postgresql.org/documentation/head/connect.html#connection- parameters Dave On 12-Sep-05, at 9:26 AM, Greg Sabino Mullane wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The difference between

Re: [PERFORM] Prepared statement not using index

2005-09-11 Thread John A Meinel
Guido Neitzer wrote: Hi. I have an interesting problem with the JDBC drivers. When I use a select like this: SELECT t0.aktiv, t0.id, t0.ist_teilnehmer, t0.nachname, t0.plz, t0.vorname FROM public.dga_dienstleister t0 WHERE t0.plz like ?::varchar(256) ESCAPE '|' withBindings: 1:53111(plz)