Hi All,
I have started using the power app and have built an app for mobile deployment for one of the crucial problems our organization is facing.
As part of the problem, I am required to fetch the data from the SQL server databases on premise and then display it to the various combo boxes in the app. Using this combo boxes data, use selects diverse options and then it is written back to the same SQL server database.
In the entire operation, reading part is the most problematic as the SQL server response is quite slow. Whereas writing is fast, though the data in writing is not significantly more than reading.
My problem is that how can I solve this issue of slow reading speed? if you look at the response of SQL server to other source of query it is as per normal standard times and doesnot need that time.
