search

RedGreenCode / UWP

Universal Windows Platform (UWP) code examples. See https://www.redgreencode.com/uwp-c-xaml-mvvm-ef-sqlite/.
Apache License 2.0
9 stars 9 forks source link

Insertion Query Slow #1

Open urjapatel opened 6 years ago

urjapatel commented 6 years ago

On Testing your sample code referring project UWP-MVVM-EF-SQLite-2, on calling db.SaveChanges() query is slow, which takes 200-300 milliseconds to save single record. How to make faster insertion queries?

RedGreenCode commented 6 years ago

My sample code integrates a few different technologies (C#, UWP, EF, SQLite). To narrow down the perf issue, you could try isolating just the SQLite call. For example, try an insert like https://stackoverflow.com/a/19489736/4803. If it runs in about the same time, then the bottleneck is either C# or SQLite. At that point you could try calling SQLite from some other environment, like Java.

urjapatel commented 6 years ago

@RedGreenCode I tried inserting, mentioned in given link https://stackoverflow.com/a/19489736/4803, still shows the same results. Can you provide a sample for Java?

RedGreenCode commented 6 years ago

http://www.sqlitetutorial.net/sqlite-java/insert/