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

From Thomas Dudziak
Subject Re: Performance problem with timestamps in result sets
Date
Msg-id 224f32340603080712l51bcef4i84d5b32c7b9f12df@mail.gmail.com
Whole thread Raw
In response to Performance problem with timestamps in result sets  ("Thomas Dudziak" <tomdzk@gmail.com>)
List pgsql-jdbc
On 3/8/06, mikael-aronsson <mikael-aronsson@telia.com> wrote:

> I do not think there is much more to do, the timestamp is just a 64 bit
> integer and you say an int takes 570ms/10920 calls and a timestamp takes
> 7130ms/8190 calls, this is about twice as much to get twice as much data.

No, thats about 16x slower (and most of the time is spent in the JDBC
driver, not on the wire).

Tom

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Performance problem with timestamps in result sets
Next
From: "mikael-aronsson"
Date:
Subject: Re: Performance problem with timestamps in result sets