Re: Unicode database + JDBC driver performance

On Mon, Dec 30, 2002 at 09:10:24AM -0800, Barry Lind wrote:
> Jan,
>
> You are correct, the 7.3 performance improvement was only implemented
> for the decode method, not the encode method, so inserts will still have
> the problem on certain jvms.
>
> You can look at the 7.3 version of org.postgresql.core.Encoding to see
> what the code is using to do character set conversions. If you want to
> submit a patch that handles the encoding case as well, that would be great.

Hello,

I wrote an optimized UTF8Encoder class, which I will send to you
in private. To finish this thread and for the archive, here are my
benchmark's results with the improved version, compared to those with
the original 7.3.1 driver (again, JDK 1.3.1 + Linux).

Take care -
JPL

INSERT benchmark

client (7.3.1 JDBC driver, old)
LATIN1 UNICODE
159 40 345 49
189 36 375 26
181 37 397 44
180 36 376 36
------- -------
177 37 373 39 111% 5% worse

client (7.3.1 JDBC driver, new)

LATIN1 UNICODE
209 27 162 30
210 37 194 27
178 33 163 28
167 29 186 33
------- -------
191 32 176 30 7% 6% better :)