web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps optimize code search w...

Power Apps

Answered

optimize code search with sql server table

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

I have a dropdown, that is searching against a table in sql server.

The dropdown is looking for option box selection.

There are only 4000 items in the table, but seems a little sluggish on returning records:

Is there a way to optimize this code for better performance ?

If(rdo_SearchChoice.Selected.Value = "Track Code", Filter('[dbo].[v_nsc_trackcode_assigned]',StartsWith(Track_code,cbo_ComboSearch.SearchText)),
rdo_SearchChoice.Selected.Value ="Seller", Filter('[dbo].[v_nsc_trackcode_assigned]',StartsWith('Aligned CSM/MAM',cbo_ComboSearch.SearchText)),
rdo_SearchChoice.Selected.Value ="Track Name", Filter('[dbo].[v_nsc_trackcode_assigned]',StartsWith(Track_Name,cbo_ComboSearch.SearchText)),
rdo_SearchChoice.Selected.Value ="Director", Filter('[dbo].[v_nsc_trackcode_assigned]',StartsWith('Director Name',cbo_ComboSearch.SearchText)))

Dave

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

I thought we simplified this in another thread...

Filter('[dbo].[v_nsc_trackcode_assigned]', Switch(rdo_SearchChoice.Selected.Value, "Track Code", StartsWith(Track_code,cbo_ComboSearch.SearchText), "Seller", StartsWith('Aligned CSM/MAM',cbo_ComboSearch.SearchText), "Track Name", StartsWith(Track_Name,cbo_ComboSearch.SearchText), "Director", StartsWith('Director Name',cbo_ComboSearch.SearchText) ) )

The results will most likely not be any faster though with that number of records and not knowing any optimizations you might have on your SQL.

Make sure that you have all 4 columns you are using in your StartsWith indexed. That would be a good first step.

Was this reply helpful? Yes No

Join the conversation