On Sat, Aug 01, 2009 at 09:37:11AM +0200, PFC wrote: >> PFC <[email protected]> writes: >>> - for short strings (average 12 bytes), sort is CPU-bound in strcoll() >>> - for longer strings (average 120 bytes), sort is even more CPU-bound in >>> strcoll() >> >> No news there. If you are limited by the speed of text comparisons, >> consider using C locale. >> > Actually, I think (see the bottom of my last email) that this would be > a > good argument for the per-column COLLATE patch...
Standard SQL COLLATE support is per column anyway, so just implementing that will solve all the problems anyway. Have a nice day, -- Martijn van Oosterhout <[email protected]> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
signature.asc
Description: Digital signature
