Does using grouped by in a list have a significant effect on performance if your have many record?

[Rain Vaine]

Hello experts,

We were tasked to investigate on utilizing grouping by in a list. Does using group by in a list cause a performance issue on the instance if there are a lot of records?

Regards,
Vaine

[Danish Bhairag2]

Hi @Rain Vaine ,

If the records are huge then for sure grouping n ungrouping records from a list view will cause high memory utilization which will lead to performance issue. But again if u r doing it as a one of inorder to check something then its fine. Many users will do it at the same time or so then yes it will definitely impact performance.

Thanks,

Danish

[Dr Atul G- LNG]

Hi @Rain Vaine 

It depends on many factor

- Table your are using

- Field

- With combination 

- Data count

- Users  doing same group by

If data is more and more it can impact.