Ability to adjust default filter under any entity

[olof]

Hi Khopper, 3 s comes for 11k records sounds unviably slow (we haven’t load tested yet). I was viewing a Espo as speed orientated but we have more accounts than that on our 10 year old sugar system and it loads in sub 300ms.

What server spec are you using? CPU, RAM, SSD? Are you apache or Ngnix?

olof.

[khopper]

I will live with it as is for now, until it 1. becomes unbearable or 2. its added as a feature through updates/enhancements.

[tanya]

Hi,
add here (in your instance) https://github.com/espocrm/espocrm/b.../Base.php#L263
if ($entityType == "{YourEntityName}") {$GLOBALS['log']->error($sql);}

After go to list view. then remove added row.
Now you can check the sql, built for getting the list. Do you see, how to optimize the query?

[khopper]

30 results at a time....top right corner shows the total number of 11,800+ records.

[tanya]

how many records per page do you display?

[khopper]

A little faster but still takes 2-3 seconds to display "Accounts".
Can I add a default filter via GUI to display the last 30 days by default for all users? (takes less than .5 seconds to display this way)

[yuri]

In the next version lists should load a bit faster.

[khopper]

Ability to add and customize default filters for all users via GUI. As the DB grows it takes longer and longer to load a page/entity such as accounts and or opportunities because the default is to show all items within that entity. Currently in my db as an example is takes 4 sec for the accounts screen to show any items. If I add a filter manually for example the last 30 days it takes less than 1 sec to display and move on.