AnsweredAssumed Answered

Performance issues on listview with million records

Question asked by Asaf Army on Dec 17, 2017
Latest reply on Dec 21, 2017 by Asaf Army



i imported a million leads into leads module.

because of that, when i push "leads" in the menu, it takes about 25 seconds to show the listview.


i read about the issue, here, in the forum.

much of the tips didn't help and i dont want to use APC, because it causes a lot of other cache problems.


setting "disable_count_query' => true," in the config file worked for me, but it disables the count on all listviews of all modules and all subpanels.

is there an option to disable count for listview and subpanel of a specific module?

non-upgrade code changes will be accepted too.



Using SugarCRM CE version