Re: Sorting Problem

Поиск
Список
Период
Сортировка
От Dennis Gearon
Тема Re: Sorting Problem
Дата
Msg-id 3F3A83AF.10603@cvc.net
обсуждение исходный текст
Ответ на Re: Sorting Problem  (Gianni Mariani <gianni@mariani.ws>)
Ответы Re: Sorting Problem
Список pgsql-general
How did you solve the problem .......... :-)

Gianni Mariani wrote:

> 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 по дате отправления:

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