Re: Unicode database + JDBC driver performance
От | Jan Ploski |
---|---|
Тема | Re: Unicode database + JDBC driver performance |
Дата | |
Msg-id | 1652601.1041448033506.JavaMail.jpl@remotejava обсуждение исходный текст |
Ответ на | Unicode database + JDBC driver performance (Jan Ploski <jpljpl@gmx.de>) |
Список | pgsql-general |
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 :)
В списке pgsql-general по дате отправления: