Answered

Create collections and make local calls or make repeated calls to remote source?

(0) Share

Report

Posted on by kman42

I have a remote mySQL database to which I make repeated calls. Is it more efficient to run a ClearCollect OnStart and gather the subset I need and then make calls to the local collection or make individual calls out to the remote database? I have a bunch of complicated labels in some galleries that need to access this data.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Pstork1 69,226 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

In general it will be more efficient to make calls against the local collection rather than round trip to the database.

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @kman42 ，
Yes.
If you store data in collection, the data processing will only work inside powerapps.
While if you call remote data from sql server, you need to transfer data everytime you call. This will spend much time.
The first way will save the time of transferring data, which will make the app perform better.
What's more, call remote sql sever will also case delegation problem while collection will not.
The delegation problem may lead to getting wrong result.

Best regards,
Community Support Team _ Phoebe Liu

Was this reply helpful? Yes No