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: 49E72C90.9010903@enterprisedb.com (view raw or flat)
Thread:
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
   EnterpriseDB   http://www.enterprisedb.com

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

Responses

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-2014 The PostgreSQL Global Development Group