Re: Fast BigDecimal - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Fast BigDecimal
Date
Msg-id Pine.BSO.4.64.0904181954340.31632@leary.csoft.net
Whole thread Raw
In response to Fast BigDecimal  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: Fast BigDecimal  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc

On Thu, 16 Apr 2009, Heikki Linnakangas wrote:

> 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.

To maintain the same behavior as the current code, you need to handle the
period more carefully.  You must ensure that there is only one and that
there's at least one other number.  Consider the case of SELECT '.' OR
SELECT '1.......'.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Fast BigDecimal
Next
From: Kris Jurka
Date:
Subject: Re: Fast BigDecimal