Answers.Body: <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>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-09-27T20:03:00.590Z
Answers.LastActivityDate: 2020-09-27T20:03:00.590Z
Answers.UserDisplayName: Laurijn
Body: <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>
  
Tags: <entries><control-panel><performance>
Title: Performance issues in CP with +60k articles database
ThreadText: # 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.
  
  
  ---
  
  