> All else being equal that is. Since this is a sort on a char() field,
> perhaps all else is not equal. In particular I'm suddenly wondering
> if your 7.0 installation was compiled with LOCALE or MULTIBYTE support
> and your 6.5 not. A few tens of thousands of strcoll() calls to do the
> sort comparisons might account for the slowdown...
Just to clarify, MULTIBYTE never calls strcoll() as far as I know.
--
Tatsuo Ishii