Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)

From: "Reuven M(dot) Lerner" <reuven(at)lerner(dot)co(dot)il>
To: Dave Cramer <pg(at)fastcrypt(dot)com>
Cc: List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)
Date: 2013-05-25 23:47:24
Message-ID: 51A14D8C.7010201@lerner.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Thanks for the suggestions, Dave; I'm traveling, but will get the added
data and post to the list ASAP. I appreciate your time and ideas.

One of your answers has piqued my curiosity, though:

> Is there an option in JDBC that can give us a more direct connection?
>
> Yes but you will have no protection from sql injection. You can use protocol 2 add protocolVersion=2 to the url
>

We don't need to worry about SQL injection in this particular
application, so far as I know. (I'll obviously check with the
developers, to make sure that it's really a zero chance, but I'm 95%
sure that it's an internal app without any external data sources.)

What else would we lose by switching to protocol version 2? Does this
version not use parameter binding? I'm just wondering what will and
won't work in protocol 2, and why it might be faster for our purposes.

Reuven

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2013-05-26 04:04:38 Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)
Previous Message Dave Cramer 2013-05-25 23:28:13 Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows)