MySQL Abfrage optimieren NOT IN und <>

[mgutt]

0.0004 seconds:

SELECT t.* FROM phpbb_topics t
WHERE t.forum_id NOT IN(0, 94, 79, 26, 17, 55, 19, 48, 27, 47, 258, 314, 351)
ORDER BY t.topic_last_time DESC
LIMIT 10

or:

SELECT t.* FROM phpbb_topics t
WHERE t.forum_id NOT IN(0)
ORDER BY t.topic_last_time DESC
LIMIT 10

0.3163 seconds:

SELECT t.* FROM phpbb_topics t
WHERE t.forum_id <> 0
ORDER BY t.topic_last_time DESC
LIMIT 10

Komisch oder?

[TobiaZ]

welche zeit erreichst du mit !=

[mgutt]

Ist genauso langsam wie <>.

Gruß