AnsweredAssumed Answered

Performance when loading accounts modules

Question asked by detroitpro detroitpro on Nov 9, 2014
The accounts module page is not loading, I started to review what was going on by following the steps in this post

I thought that the follow guideline would help:

Disable record paging in the detailview (VCR controls) - Increases performance by not loading all records from a listview into memory when accessing the record detailview
Because when I check mysql, using "show full processlist" when going to the account module the query does not use any limit. 

See here:

In my case this is loading over a million records in memory for the first page, the paging defaults of 20 records per page have not been changed.

Question: Is there any way to limit the number of records returned?

Version 6.5.18 (Build 1110)