Uploaded image for project: 'Planet4'
  1. Planet4
  2. PLANET-5439

Apply performance optimization to blocks report


    • Icon: Task Task
    • Resolution: Released
    • Icon: Should have Should have
    • 2.39.1
    • None
    • 2
    • Blocks (all), Performance
    • Sprint #144

      We can speed up the query that is used to generate the blocks report quite a lot by adding a condition on the post type to it, searching only through types post, page and campaign EDIT: so that it only searches types that could have blocks (NROs could have other types with blocks, we can get these types dynamically when doing the query).

      Doing so the blocks report on test-deimos (which has data from international) went from around 20 seconds to load, to around 5. The speed improvement will differ for each NRO, depending on how many posts of other types are in the database.

      branch: https://github.com/greenpeace/planet4-plugin-gutenberg-blocks/compare/faster-blocks-report

            pvincent Pieter Vincent (Inactive)
            pvincent Pieter Vincent (Inactive)
            0 Vote for this issue
            0 Start watching this issue