Biztos? A drupaltest adatbazison? Most már futtattam elég sokat. Elsőre 25 sec volt.
Ezt most futtattam mysql restart után:
mysql> use drupaltest; Database changed
mysql> SELECT c.nid, c.subject, c.cid, c.timestamp FROM comments c INNER JOIN node n ON n.nid = c.nid WHERE n.status = 1 AND c.status = 0 ORDER BY c.timestamp DESC LIMIT 0, 15;
+-------+------------------------------+--------+------------+
15 rows in set (26.50 sec)
--
trey @ gépház