Re: Performance tweaks - Mailing list pgsql-jdbc

From Ken Geis
Subject Re: Performance tweaks
Date
Msg-id 421C3CBE.8020309@speakeasy.net
Whole thread Raw
In response to Re: Performance tweaks  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Oliver Jowett wrote:

> Ken Geis wrote:
>
>> First, in PGStream, I "unrolled" SendInteger4 and SendInteger2, like
>> this:
>>
>>     private static final byte[] B4 = new byte[4];
>>     public void SendInteger4(int val) throws IOException
>>     {
>>         B4[0] = (byte) ((val >> 24)&255);
>>         B4[1] = (byte) ((val >> 16)&255);
>>         B4[2] = (byte) ((val >> 8)&255);
>>         B4[3] = (byte) (val&255);
>>         pg_output.write(B4, 0, 4);
>>     }
>
>
> This isn't safe across multiple PGStreams. Can you try benchmarking
> again with "private final" instead of "private static final"? If that's
> still a win it is probably worth changing.

I tested it more rigorously with this change.  Not a win.


pgsql-jdbc by date:

Previous
From: Ken Geis
Date:
Subject: Re: Performance tweaks
Next
From: Markus Schaber
Date:
Subject: Re: [postgis-devel] JDBC & WKB - 400% overhead