| From: | Gunnar Rønning <gunnar(at)polygnosis(dot)com> |
|---|---|
| To: | "George Koras" <gkoras(at)cres(dot)gr> |
| Cc: | "Barry Lind" <barry(at)xythos(dot)com>, "Arsalan Zaidi" <azaidi(at)directi(dot)com>, "PostgreSQL jdbc list" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: Re: [INTERFACES] New code for JDBC driver |
| Date: | 2001-07-05 10:23:27 |
| Message-ID: | m2ae2ju128.fsf@smaug.polygnosis.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces pgsql-jdbc |
* "George Koras" <gkoras(at)cres(dot)gr> wrote:
|
| Yes, I agree that it certainly has to be done before SQL is sent to the
| driver, i.e. in the middle tier!
| Is it a performance bottleneck? Would PreparedStatement be more efficient?
|
Depends on your application, but doing escaping on all queries would
certainly increase the overhead for some queries.
With PreparedStatement you only escape the part of the query that is string
input, so, yes, it would be more efficient.
--
Gunnar Rønning - gunnar(at)polygnosis(dot)com
Senior Consultant, Polygnosis AS, http://www.polygnosis.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | NTB Technical Support | 2001-07-05 15:48:57 | ADO and ODBC: More |
| Previous Message | George Koras | 2001-07-05 10:20:40 | Re: Re: [INTERFACES] New code for JDBC driver |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-07-05 16:20:55 | Re: Metadata for tables, schema, and numeric |
| Previous Message | George Koras | 2001-07-05 10:20:40 | Re: Re: [INTERFACES] New code for JDBC driver |