Re: UPDATE in Kombination mit ORDER BY sehr langsam
Ja, klar.
Hier die Ausgabe des EXPLAIN:
+----+-------------+----------------------------+------+-----------------+-----------------+---------+-------+---------+-----------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+----------------------------+------+-----------------+-----------------+---------+-------+---------+-----------------------------+
| 1 | SIMPLE | highscores | ref | idx_spielmodus | idx_spielmodus | 5 | const | 1230952 | Using where; Using filesort |
+----+-------------+----------------------------+------+-----------------+-----------------+---------+-------+---------+-----------------------------+
Die beiden Indizes hab ich schon wieder weggeschmissen.
Danke und Gruß,
Tobias.
Subject
Views
Written By
Posted
2053
July 30, 2012 04:30AM
1026
August 01, 2012 03:06AM
1153
August 06, 2012 10:40AM
1024
August 08, 2012 06:09AM
1057
August 08, 2012 09:26AM
1194
August 08, 2012 09:50AM
1219
August 09, 2012 02:22AM
902
August 09, 2012 02:20AM
1244
August 09, 2012 02:45AM
1066
August 09, 2012 03:20AM
1062
August 09, 2012 03:31AM
Re: UPDATE in Kombination mit ORDER BY sehr langsam
991
August 09, 2012 03:47AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.