Re: [development] Two performance improvements

This query isn't using an index either.

This one also i think: SELECT n.nid FROM node n INNER JOIN i18n_node a ON n.nid = a.nid INNER JOIN i18n_node b ON a.trid = b.trid AND b.nid =74 WHERE n.nid != 74 AND n.language = 'de' explain: 1 | SIMPLE | n | eq_ref | PRIMARY | PRIMARY | 4 | newsaltek.a.nid | 1 | Using where This one is used pretty often, i suggest creating an index on language, but i am not sure if this is only the patch from i18n? Jakub Suchy