TI Groups Page Loads Slowly

[gwendolyngoetz]

Loading the TI Groups Page is slow in Seattle (prod). 12 seconds+

/admin/tiGroups

The query either needs optimizing or we need to look into caching TI data

[gwendolyngoetz]

@dkatzz FYI

[melanie-exygy]

@gwendolyngoetz I just want to clarify that routes starting with admin/tiGroups aren't for the TI dashboard. Those are for the admin TI configuration. Routes for the TI dashboard start with admin/tiDash. IMO in would be best to change the name of this issue and the description to avoid confusion.

[dkatzz]

@gwendolyngoetz I just want to clarify that routes starting with admin/tiGroups aren't for the TI dashboard. Those are for the admin TI configuration. Routes for the TI dashboard start with admin/tiDash. IMO in would be best to change the name of this issue and the description to avoid confusion.

Makes sense! Yeah I can imagine this query getting slow with lots of groups and also we load all the members and managed accounts when we really just need the counts. Let me know if we need someone to work on this and I can take a pass.

Some ideas:

• Select only the attributes we need in the account repository query - https://ebean.io/docs/query/select
• Consider refactoring findList to findEach - https://ebean.io/docs/query/findList
• Create a query that uses findRowCount instead of loading the ManyToMany associations