Reducing your application complexity by using Azure SQL database views

Performance is one of the main objectives of almost all data source engines. Database developers tweak the innards of their core systems to make them as efficient as possible while also adding new features for app makers. Knowing this, why not leverage the efficiency of these platforms?

That's the primary purpose of this recipe, to learn how to improve our apps' responsiveness and complexity by making the data sources work for us.

Getting ready

We will improve the application's complexity and performance when connected to an Azure SQL database to build our use case. The database needs five tables that will make up our data catalog. The scripts to create them and the base apps are available in our GitHub repository: https://github.com/PacktPublishing/Microsoft-Power-Apps-Cookbook/tree/master/Chapter03

If you don't have an Azure subscription, you can request a free version with credit...