1 Aug
2006
1 Aug
'06
8:47 a.m.
On 01 Aug 2006, at 02:39, Derek Wright wrote:
i had killes run this query w/ and w/o the INNER JOIN on {cvs_repositories}. he posted the results in http://drupal.org/ node/74238 (the issue in the cvs.module's queue about fixing all this stuff). the results are that we end up with a tablesort on the query in both cases. so, i don't think re-organizing the code to do the equivalent of the INNER JOIN in php code is going to help. i think this is just a big, nasty, slow query, and i'm not sure there's much we can do about it.
Did you try to change the order of the JOINs? I don't think it will make a big difference but it is worth a try. -- Dries Buytaert :: http://www.buytaert.net/