Re: Performance problem with timestamps in result sets

Поиск
Список
Период
Сортировка
От Steve Wampler
Тема Re: Performance problem with timestamps in result sets
Дата
Msg-id 20060308162543.GA29522@weaver.tuc.noao.edu
обсуждение исходный текст
Ответ на Re: Performance problem with timestamps in result sets  ("mikael-aronsson" <mikael-aronsson@telia.com>)
Ответы Re: Performance problem with timestamps in result sets
Список 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 по дате отправления:

Предыдущее
От: David Goodenough
Дата:
Сообщение: Problem with background thread in Tomcat 5.5.9
Следующее
От: Nikola Milutinovic
Дата:
Сообщение: Re: Connection String