It turns out that the sql table in which I search or filter has approximately 6000 records and when doing the search is very slow, then I would like to know how I can perform a search and that it is as fast as possible.
Hello Pealpy,
Working with a table with 6,000 records should not cause any significant delays, unless the app runs on a slow hardware (older mobile devices for example).
The best way to optimize your query is to ensure you use delegable functions as much as possible. Please see this: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-list
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
204 | |
182 | |
72 | |
44 | |
35 |
User | Count |
---|---|
331 | |
267 | |
116 | |
70 | |
65 |