From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
---|---|
To: | psycopg(at)postgresql(dot)org |
Subject: | Re: Input and Output data traffic |
Date: | 2011-05-11 17:29:41 |
Message-ID: | 20110511172941.GS6613@hermes.hilbert.loc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | psycopg |
On Wed, May 11, 2011 at 01:56:08PM -0300, Israel Ben Guilherme Fonseca wrote:
> With the log tips of Oswaldo, I saw that
>
> SET TRANSACTION ISOLATION LEVEL READ COMMITTED
>
> on every instruction as you said Danielle. JDBC dont have those and it use
> parameters for the statements, psycopg do not (its embedded in the SQL). I
> dont know if this could have some impact.
>
> I used the recommended way to avoid SQL Injection by the way.
>
> execute("insert into table(col) values(%s)", (10,))
I wonder how any of this is supposed to have any impact on
the expected up-/down-traffic ratio which was the only thing
the OP reported to be different between psycopg2 and JDBC
(if I correctly understood the original post).
Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
From | Date | Subject | |
---|---|---|---|
Next Message | Israel Ben Guilherme Fonseca | 2011-05-11 17:37:28 | Re: Input and Output data traffic |
Previous Message | Israel Ben Guilherme Fonseca | 2011-05-11 16:56:08 | Re: Input and Output data traffic |