Re: Performance problem with timestamps in result sets

From: Steve Wampler <swampler(at)noao(dot)edu>
To: mikael-aronsson <mikael-aronsson(at)telia(dot)com>
Cc: 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 16:25:43
Message-ID: 20060308162543.GA29522@weaver.tuc.noao.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)noao(dot)edu
The gods that smiled on your birth are now laughing out loud.

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Nikola Milutinovic 2006-03-08 16:46:40 Re: Connection String
Previous Message David Goodenough 2006-03-08 15:54:33 Problem with background thread in Tomcat 5.5.9