Performance problem with timestamps in result sets

From: "Thomas Dudziak" <tomdzk(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Performance problem with timestamps in result sets
Date: 2006-03-08 14:24:11
Message-ID: 224f32340603080624n1bada47fw8cc2c1b19f7d3914@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On 3/8/06, Michael Paesold <mpaesold(at)gmx(dot)at> wrote:

> What profiler are you using? What are the settings?
> Profiling can add significant overhead...

YourKit 5.1.1 (newest version) against Java 5 Update 6, with method
timing and invocation counting (which makes it somewhat slower, I'd
say 10-15%).
The interesting figure is that getTimestamp takes 10x more than
getString or getInt.

Tom

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Michael Paesold 2006-03-08 14:50:52 Re: Performance problem with timestamps in result sets
Previous Message Michael Paesold 2006-03-08 14:21:47 Re: Performance problem with timestamps in result sets