From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | "Reuven M(dot) Lerner" <reuven(at)lerner(dot)co(dot)il> |
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-26 04:04:38 |
Message-ID: | CADK3HHL0pEZB7-m+8MwHCHPr=RUvhY6jYrCKf1ZsjsGUUNXqcg@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On Sat, May 25, 2013 at 7:47 PM, Reuven M. Lerner <reuven(at)lerner(dot)co(dot)il>wrote:
> 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.
>
>
Well actually at pgcon this week the developers talked about deprecating
protocol 2. It does not use binding it builds the query into a string and
does param replacing before executing the query.
I'd really prefer to understand this issue.
Thanks!
Dave
From | Date | Subject | |
---|---|---|---|
Next Message | Edson Richter | 2013-05-26 14:38:45 | Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows) |
Previous Message | Reuven M. Lerner | 2013-05-25 23:47:24 | Re: Bound parameters on Linux are extremely slow (compared to unbound and/or Windows) |