Hi! I have 40k+ records in Azure SQL, which I am fetching in my PowerApps gallery. I am using the Filter function and sort methods there. As the gallery has multiple (13+ filters) and sorting buttons on all the columns, the system works fine for a few hundred records but it gets very slow with 20k+ records, even though the system pulls just 2k records at a time. Can u pls guide or help in any way?
Following is the filter method with some formulae that I am using.
Filter(
collWATable,
(txtSearchCaseNumber_4.Text in 'Case Number' || IsBlank(txtSearchCaseNumber_4)) , (txtSearchNotes_4.Text in 'Case Code' || IsBlank(txtSearchNotes_4)), (cbSearchDoer_4.Selected.Mail in Doer || IsBlank(cbSearchDoer_4.Selected))
, (cbSearchChecker_4.Selected.Mail in Checker || IsBlank(cbSearchChecker_4.Selected) ), Text(dtSearchTarget_4.SelectedDate) in 'Case Target Completion Date',(txtSearchBGroup.Text in BGroup || IsBlank(txtSearchBGroup)),(ddSearchRangeFilter.Selected.Value in Text('Number of working days to complete (Range)') || ddSearchRangeFilter.Selected.Value = "All"),(txtSearchAllocatedTeam.Text in 'Owner Team' || IsBlank(txtSearchAllocatedTeam)),(txtSearchSLAStatus.Text in 'SLA Status' || IsBlank(txtSearchSLAStatus)), (txtSearchIPACaseStatus.Text in 'Case Stage' || IsBlank(txtSearchIPACaseStatus)), (ddSpecialIndicator.Selected.Value in 'Specialist Indicator' || ddSpecialIndicator.Selected.Value = "All"), (Status in comboStatusFilter.SelectedItems || comboStatusFilter.Selected.Value = "All Cases"))
