Consider using model-driven apps for managing complex data imports, as they provide built-in tools for data consistency and accuracy Key Considerations for Excel to Power App Conversion ...

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 for your app.