Problem/Motivation

The release 1.0.72 changes result in even slower query results, on my high performance server it took 46 seconds to load a report that was passing through only about 4000 nodes and 4000 menu link entities.

I have a performance improved version to push up. It has to do a uksort and a ksort in php to get the parents ordered alphabetically but less cost. The query has been redone.

Steps to reproduce

Install safedelete_menu_report on a site with greater than 3000 nodes and 3000 menu links, notice that the report is slow. Want faster reporting.

Proposed resolution

New release to follow, new code.

Remaining tasks

Develop, test, review , tag a release and release.

User interface changes

N/A

API changes

The ReportService has been changed, results from this service are not sorted but instead need to sort them in the ReportHelper instead.

Data model changes

Comments

joseph.olstad created an issue. See original summary.

  • joseph.olstad committed f7970dc2 on 1.0.x
    [#3546255] feat: Improve the performance of the ReportService query
    
    By...
joseph.olstad’s picture

Assigned: joseph.olstad » Unassigned
Status: Active » Fixed

Now that this issue is closed, please review the contribution record.

As a contributor, attribute any organization helped you, or if you volunteered your own time.

Maintainers, please credit people who helped resolve this issue.

joseph.olstad’s picture

joseph.olstad’s picture

Issue tags: +Performance

Status: Fixed » Closed (fixed)

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