Currently I has hard time with my site with damn a lot of content. One of bottlenecks is relevance SQL query in relevance.module.

I think MySQL just can't optimize really good SQL where subquery is added as "field IN (SELECT subquery)".

That's why I've rewrote the whole request with joins. Not sure if it will help all, but for me it helped to make this query to be as fast as few ms instead of thousands of seconds.

Patch attached.

CommentFileSizeAuthor
releveance.module.patch867 bytespavel.karoukin

Comments

fernao’s picture

fernao commented

Hi there, thanks for the patch!

I'll take a look and probably make a new release with it and another fixes.

Fernão

fernao’s picture

fernao commented

Commited to version 6-x-2.2 (http://drupal.org/node/539332)

fernao’s picture

fernao commented
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.