| From: | Dennis Gearon <gearond(at)cvc(dot)net> |
|---|---|
| To: | Gianni Mariani <gianni(at)mariani(dot)ws> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Sorting Problem |
| Date: | 2003-08-13 18:30:07 |
| Message-ID: | 3F3A83AF.10603@cvc.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Gearon | 2003-08-13 18:33:31 | Re: Sorting Problem |
| Previous Message | Dennis Gearon | 2003-08-13 18:27:03 | Re: Sorting Problem |