then SQL is your option. There are various performance considerations within the Power Platform. Now if you have decided to use Dataverse then Model Driven Apps may give you the right performance ...