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 :)