just wondering if anybody here noticed an issue that with increasing amount of subjects the Administer Subjects page loading is not scaling well. The subjects are paginated but the page loads slower and slower and with 5k subjects the load time is starting to be noticeable. Similar slowness is present when navigating between Subjects datatable pages or when sorting the datatable. Have anybody seen such behaviour? Could it be that SQL query for this view is not optimised well?
Seem to me that this is the case because e.g. when loading Subject Matrix for study with 3k patients the page load is fast, as well as sorting and navigation between StudySubjects datatable pages.
any feedback on this issue is welcome
thanks and best