Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance problem with timestamps in result sets - Mailing list pgsql-jdbc

From Michael Paesold
Subject Re: Performance problem with timestamps in result sets
Date
Msg-id 060a01c642bf$b3060220$9001a8c0@zaphod
Whole thread Raw
In response to Performance problem with timestamps in result sets  ("Thomas Dudziak" <tomdzk@gmail.com>)
Responses Re: Performance problem with timestamps in result sets
List pgsql-jdbc
Tree view 
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

pgsql-jdbc by date:

Previous
From: "Thomas Dudziak"
Date:
Subject: Performance problem with timestamps in result sets
Next
From: "Thomas Dudziak"
Date:
Subject: Re: Performance problem with timestamps in result sets