Re: Sorting Problem

Поиск
Список
Период
Сортировка
От Gianni Mariani
Тема Re: Sorting Problem
Дата
Msg-id 3F3A8027.6080905@mariani.ws
обсуждение исходный текст
Ответ на Re: Sorting Problem  (Dennis Gearon <gearond@cvc.net>)
Ответы Re: Sorting Problem
Re: Sorting Problem
Список pgsql-general
Dennis Gearon wrote:

> I agree with all of that except for one caveat:
>
>     all my reading, and just general off the cuff thinking, says that
> processing variable width characters SIGNIFICANTLY slows an
> application. It seems better to PROCESS fixed width characters (1,2,4
> byte), and TRANSMIT variable width characters (avoiding the null
> problem.)


I can and have solved that problem.  If you can assume utf-8 encoding
then there are available to you a bunch o tricks that takes this problem
away.

The other problem with memory (and hence cache) utilization of a wide
char only solution it far more significant.
Cache effects are the primary killer for performance in an app like a
database.

Anyhow, before making any "decisions" one should do a bunch of analysis.

Cheers
G




В списке pgsql-general по дате отправления:

Предыдущее
От: "Maksim Likharev"
Дата:
Сообщение: Re: Sorting Problem
Следующее
От: Dennis Gearon
Дата:
Сообщение: Re: Sorting Problem