dotnet/efcore

Investigate perf with EF Core on MAUI

Open

Aperta il 21 mag 2018

Vedi su GitHub
 (28 commenti) (28 reazioni) (1 assegnatario)C# (14.651 star) (3376 fork)batch import
area-perfarea-platformcustomer-reportedhelp wanted

Descrizione

In developing a Xamarin Android app using Entity Framework Core 2.0 with a code-first approach using a Sqlite database provider, the initialisation time seems pretty slow. For approximately 40 models (and a practically empty database) the app takes around 14 seconds to launch, 10 seconds for the call to Migrate(), and another 3-5 seconds for the first query after that. Once those are done it seems to be fine. There's barely any difference in initialisation time between Release and Debug builds.

I'm not sure if it relates to #4372 or #1906, but it may well do.

Is there anything I can do to help mitigate the initialisation time?

Guida contributor

Tech stack
csharpsqliteandroid
Dominio
performancemobiledatabase
Tipo issue
performance
DifficoltàQuanto dovrebbe essere impegnativa per un nuovo contributor.
4
Tempo stimatoTempo stimato per completare e verificare uno scope piccolo.
over 1 week
Stato attivitàQuanto è probabile che la issue sia ancora attiva e reviewable.
stale
ChiarezzaQuanto chiaramente la issue descrive problema, scope e risultato atteso.
needs investigation
Prerequisiti
C#Entity Framework CoreMAUI/Xamarinperformance profiling
Adatta ai principiantiQuanto la issue è adatta a contributor alla prima esperienza.
15
Direzione di ricerca
Profile the Migrate() and first query calls in a MAUI Android app with EF Core 2.0 and SQLite. Investigate related issues #4372 and #1906 for potential duplication. Focus on identifying bottlenecks in model initialization and database provider setup. Review current EF Core and MAUI documentation for performance recommendations.