[development] Drupal.org slow queries analyzed with explain: CVS tables

[Dries Buytaert]

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/