Hi,
When I try to sort the alphabet, the three characters only used for the
norwegian language, Æ, Ø and Å, are sorted wrong. They should be sorted in
the order ÆØÅ, but they're sorted ÅÆØ.
I read some place that I could change the character-set to danish, and that
that would solve the issue (as
Bruce,
Bruce Leidl schrieb:
>
> I'm having a problem with some very slow queries that spend a very long
> time in the 'Sorting result' state and I'm wondering how sorts are
> implemented in mysql and what I can do to optimize these types of queries.
>
&g
doing the sort and throwing away all but the last 50.
I don't know if that was clear or not, but what I'm trying to say is, if you
can limit the amount of data that matches the WHERE that you're going to be
throwing out anyway, do it. :)
> -Original Message-
> From:
Sorts don't use indexes, for the most part, only the search part does.
Someone correct me if I'm wrong on that, I think I recall reading it in
SQL for Smarties. The index is on the entire database, not on the
subset that you have selected. If you know that your query is going to
retu
I'm having a problem with some very slow queries that spend a very long
time in the 'Sorting result' state and I'm wondering how sorts are
implemented in mysql and what I can do to optimize these types of queries.
The query looks something like this:
SELECT col1,col2,co
x27;t think there is a easy way.
> Here are some of the variables SHOW STATUS returns
>
> Questions 6623371
> Sort_merge_passes 357
> Sort_range 29213
> Sort_rows 11271509
> Sort_scan 231944
>
> I want to try and calculate the percentage of sorts that require
sorts that required more than
one pass!!
Any help would be welcome.
Thanks
Peter Kelly
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
