Hi Guys,

I'm not quite sure what to make of this, or even if it is part of this module. Unfortunately I'm not in a position to be able to disable sections from this site to test, so thought I'd post it as a low priority issue :)

I'm currently trawling through Devel's query log to try and squeeze a little performance out of the site. I've noticed that on pages which are just displaying views, the function "sections_in_sections" is executing on between 20-50 times per page load. The same query is always executing, which is:

SELECT DISTINCT s.* FROM sections_data s LEFT JOIN sections_roles r ON s.sid = r.sid WHERE s.status = 1 AND (r.rid IN (2) OR r.rid IS NULL) ORDER BY s.weight

In this case, the query is taking anywhere between 2 and 05ms to fire.

There is one page, however, where this seems to become a rather large problem. I'm using the Finder module with a View. On that page, this particular function (and query) is firing 3549 times, taking anywhere between 0.14ms to 6.45ms. I've not counted total time for this, but it'll be a few seconds. For the most part I've countered this with Boost, but thought it might be worth reporting as well :)

If this is not part of the Sections module, I apologise :)

Cheers,
Josh

Comments

hass’s picture

Component: Miscellaneous » Code
Category: support » bug
Priority: Minor » Major
Status: Active » Closed (duplicate)

I cannot believe that a count of 3549 is correct, but this performance issue has been fixed in latest DEV.

jfarry’s picture

I'll download the dev version and give it a hit :) Thanks! :D