Re: Sorting Problem - Mailing list pgsql-general

From Dennis Gearon
Subject Re: Sorting Problem
Date
Msg-id 3F3A83AF.10603@cvc.net
Whole thread Raw
In response to Re: Sorting Problem  (Gianni Mariani <gianni@mariani.ws>)
Responses Re: Sorting Problem  (Gianni Mariani <gianni@mariani.ws>)
List 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 by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: Sorting Problem
Next
From: Dennis Gearon
Date:
Subject: Re: Sorting Problem