List view performance issue possible root causes

[zheil]

Hi All

Some of our users experience an unusual performance issue and I would like to know if anyone has experienced anything similar.

The issue is that certain list views load in seconds for most of the users, but for some other users those views load in 60+ seconds. Network and browser response times are okay, while server response times are high.

There is no difference between the impacted and not impacted users' settings, no difference between their browser, location, users are in the same groups, list view ordering is the same, instances without read-replica are also impacted so this is not a replica issue, and the issue is consistent and reproducible at any time.

Any thoughts?

[Subhajit1]

Chances are that the lists facing the issue have too many columns that are Populating during List Load and there are too many Reference columns or too many Dot walked fields.

Thanks,

Subhajit

[zheil]

Hi Subhajit Das

Thanks for your comment. There are only 7 columns in the view and 3 one-level dot walked fields. There are views with far more dot walked fields and those views are not impacted. We will try to add an index, but it's still not clear why only some users are impacted.

[Swapna Abburi]

Hi Zalan,

Show records count also matters in list view. Can you check if this is causing the issue?

[zheil]

Hi swabburi and Subhajit Das

Thanks for your comments, unfortunately the record count does not come into play here, only 20 records are listed per page for impacted users.