Re: Performance problem with timestamps in result sets

Поиск
Список
Период
Сортировка
От Thomas Dudziak
Тема Re: Performance problem with timestamps in result sets
Дата
Msg-id 224f32340603080712l51bcef4i84d5b32c7b9f12df@mail.gmail.com
обсуждение исходный текст
Ответ на Performance problem with timestamps in result sets  ("Thomas Dudziak" <tomdzk@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Oliver Jowett
Дата:
Сообщение: Re: Performance problem with timestamps in result sets
Следующее
От: "mikael-aronsson"
Дата:
Сообщение: Re: Performance problem with timestamps in result sets