[development] Two performance improvements

Jakub Suchy jakub at rtfm.cz
Wed Jul 12 20:50:14 UTC 2006


> 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


More information about the development mailing list