cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pealpy
Regular Visitor

How can I filter or search data from sql server and only show me the matches of what I'm looking for

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.

1 REPLY 1
Microsoft
Microsoft

Re: How can I filter or search data from sql server and only show me the matches of what I'm looking

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

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (5,939)