<p>Doing further research i noticed the performance impact is mainly due to sorting on the default publication date. When sorting on the title field all the performance issues are gone.</p>

CC BY-SA 4.0
2020-09-27T20:03:00.590Z
2020-09-27T20:03:00.590Z
Laurijn
<p>We are are working with a large dataset of over 60k articles. The craft control panel has a very hard time loading the entries list tables. Using debug I see that the queries that takes up the longest (+10s) is the one that starts likes this &quot;SELECT sourceId AS source, targetId AS target&quot; . Does anyone has any ideas or tips on how we can get around/fix this issue?</p>
<p>This is an image form the debugger on the ajax call loading a list of entries in the contents tab.</p>
<p><a href="https://i.sstatic.net/mjBjw.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/mjBjw.png" alt="enter image description here" /></a></p>

<entries><control-panel><performance>
Performance issues in CP with +60k articles database
# Performance issues in CP with +60k articles database

(Asked by: username_0 on 2020-09-27)

We are are working with a large dataset of over 60k articles. The craft control panel has a very hard time loading the entries list tables. Using debug I see that the queries that takes up the longest (+10s) is the one that starts likes this "SELECT sourceId AS source, targetId AS target" . Does anyone has any ideas or tips on how we can get around/fix this issue?

This is an image form the debugger on the ajax call loading a list of entries in the contents tab.

[![enter image description here](https://i.sstatic.net/mjBjw.png)](https://i.sstatic.net/mjBjw.png)

**Tags:** entries, control-panel, performance

---

## 1 answers

### Answer by username_0 on 2020-09-27. Score: 2

Doing further research i noticed the performance impact is mainly due to sorting on the default publication date. When sorting on the title field all the performance issues are gone.


---

