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