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

From Steve Wampler
Subject Re: Performance problem with timestamps in result sets
Date
Msg-id 20060308162543.GA29522@weaver.tuc.noao.edu
Whole thread Raw
In response to Re: Performance problem with timestamps in result sets  ("mikael-aronsson" <mikael-aronsson@telia.com>)
Responses Re: Performance problem with timestamps in result sets
List pgsql-jdbc
On Wed, Mar 08, 2006 at 04:08:13PM +0100, mikael-aronsson 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.

Eh?  7130 / 8190.0 = 0.8705738705738706
      570 /10920.0 = 0.0521978021978022

Which is >16X difference.  While may be as much as can be done, it's
more than twice as much to get twice the data.

--
Steve Wampler -- swampler@noao.edu
The gods that smiled on your birth are now laughing out loud.

pgsql-jdbc by date:

Previous
From: David Goodenough
Date:
Subject: Problem with background thread in Tomcat 5.5.9
Next
From: Nikola Milutinovic
Date:
Subject: Re: Connection String