Re: Performance problem with timestamps in result sets

From: "Michael Paesold" <mpaesold(at)gmx(dot)at>
To: "Thomas Dudziak" <tomdzk(at)gmail(dot)com>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Performance problem with timestamps in result sets
Date: 2006-03-08 14:50:52
Message-ID: 060a01c642bf$b3060220$9001a8c0@zaphod
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Thomas Dudziak wrote:

> -> AbstractJdbc2ResultSet.getTimestamp(int) : 7130ms | 8190 calls
>
> Now my question is, is there something to make this faster ? Nearly
> 1sec for a ResulSet.getTimestamp call is too much for us.

This should be 1 ms per getTimestamp call, shouldn't it? The time is the
aggregate time for ~8000 calls. That is still rather slow, yeah, but it is
so with profiling.

Best Regards,
Michael Paesold

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Thomas Dudziak 2006-03-08 14:57:21 Re: Performance problem with timestamps in result sets
Previous Message Thomas Dudziak 2006-03-08 14:24:11 Performance problem with timestamps in result sets