Re: Unicode database + JDBC driver performance

On Mon, Dec 23, 2002 at 09:52:28AM -0800, Barry Lind wrote:
> Jan,
>
> You say you are using 7.2.1, is that for both server and jdbc driver?
> There is a performance patch in the 7.3 driver that bypasses the built
> in java routines for converting to/from utf8 with a custom one.  The
> built in java routines are very slow on some jdks (although on jdk1.4
> they are pretty good).  Can you try the 7.3 drivers?
>
> thanks,
> --Barry

Hello,

I was using the 7.2.2 JDBC driver and 7.2.1 backend in the original
benchmark. The Java runtime version was Sun's 1.3.1. I repeated the same
tests today with the 7.3 JDBC driver. The results, together with the older
driver's figures for comparison, are pasted below. The SELECT performance
is definitely improved, but the INSERT performance got even worse.

You are right. The difference is not there when I am using Sun's 1.4.

Could it be that the improvement you mentioned does not apply there?

Take care -
JPL


SELECT benchmark

client (7.3.1 JDBC driver)
LATIN1      UNICODE
212  22     281  29
222  29     275  36
216  26     275  19
228  21     275  17
-------     -------
220  25     277  25     26% worse

client (7.2.2 JDBC driver)
LATIN1      UNICODE
217  22     529  14
217  18     544  25
217  26     534  14
219  21     542  17
-------     -------
218  22     537  18     146% worse


INSERT benchmark

client (7.3.1 JDBC driver)
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.2.2 JDBC driver)
LATIN1      UNICODE
234  45     418  56
224  56     441  48
241  43     430  49
222  41     439  34
-------     -------
230  46     432  47     87% 2% worse