[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