# Idea OP-8482 - Improve Peformance of Paginators

Project: OpenProject
Status: new
URL: https://community.openproject.org/work_packages/OP-8482

## RICE

| Attribute | Value |
| --- | --- |
| Reach | 10.0 = Impacts the vast majority (~80% or greater) |
| RICE Score | 13.33 |
| Votes |  |

## Requires

_No work packages_

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable |  |
| Product manager |  |

## Details

| Attribute | Value |
| --- | --- |
| Roadmap |  |
| Date |  |
| Target versions | Wish List |
| Module |  |
| Priority | Medium |
| List |  |
| Interest by |  |
| Labels |  |

## Estimates and progress

| Attribute | Value |
| --- | --- |
| PD (min) |  |
| PD (max) |  |

## Description

Hi everyone,

I noticed that OpenProject takes quite some time to load larger tables. See an example below.

It reminded me of the very same issue in our internal projects. Many of our customers complaint. First we solved it by deploying/requesting more and better hardware. This solved the issue only partially. We reduced and tweaked related database queries as the second measure. In the end, we found a sustainable solution to massively reduce the perceived slowness of our products. The solution was to split loading the table into two unrelated things:

1.  95% of the visible content: loading the headers and rows of the table (usually extremely fast to pull 20 or 50 items from the database)
2.  5% of the visible content: loading the paginator (which includes the count of the found elements - the **real problem**) via AJAX afterwards in a separate request (using cache framework to store the original db query)

We devised a table framework which does the split automatically. So, all tables we have implemented over the years already benefited from this.

Would be great if this could be done in OpenProject as well as it would improve acceptance/adoption within the company considerably.

Cheers  
Sven

  

**PS:**

Same holds true for set of tiles and gantt charts; which are great features btw.

**Talking about this AJAX request here:** https://community.openproject.org/api/v3/queries/default?pageSize=50&amp;columns%5B%5D=id&amp;columns%5B%5D=subject&amp;columns%5B%5D=type&amp;columns%5B%5D=status&amp;columns%5B%5D=assignee&amp;columns%5B%5D=project&amp;timelineVisible=false&amp;displayRepresentation=card&amp;highlightedAttributes%5B%5D=status&amp;highlightedAttributes%5B%5D=priority&amp;highlightedAttributes%5B%5D=dueDate&amp;showHierarchies=true&amp;groupBy=&amp;filters=%5B%7B%22status%22%3A%7B%22operator%22%3A%22o%22%2C%22values%22%3A%5B%5D%7D%7D%5D&amp;sortBy=%5B%5B%22id%22%2C%22asc%22%5D%5D&amp;offset=1

**Found on this page:** https://community.openproject.org/work\_packages

<figure class="image op-uc-figure"><div class="op-uc-figure--content"><img class="op-uc-image" src="/api/v3/attachments/20835/content"></div></figure>
