Skip site navigation (1) Skip section navigation (2)

Fast BigDecimal

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Fast BigDecimal
Date: 2009-04-16 13:03:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
Here's another patch I put together while trying to improve performance 
for the customer that bumped into the repeated Describe thing yesterday. 
It speeds up ResultSet.getBigDecimal() with the same fastpath 
implementation we have for getInt and getLong.

I'm testing this with a test program that reads 10000 rows from a table 
with 100 numeric columns, calling getBigDecimal() on each column. This 
patch cuts the execution time roughly in half, from 2.4s to 1.2s.

   Heikki Linnakangas

Attachment: fast-getbigdecimal-2.patch
Description: text/x-diff (2.7 KB)


pgsql-jdbc by date

Next:From: Kris JurkaDate: 2009-04-18 23:56:20
Subject: Re: Fast BigDecimal
Previous:From: John ListerDate: 2009-04-16 11:26:25
Subject: Re: Query preparation

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group