Regarding query execution time in Visual studio and SQLite browser

Question

Hi Team,

one update query execution time in SQLite browser is 59432ms.

In Visual studio same query execution time is 396114ms.

How to reduce the execution time in Visual studio?

Query: update Table_People As A SET FirstLevelParentID = A.ParentID from Table_Places As B inner join Table_People As C on C.ParentID == B.PlaceID and A.FirstLevelParent!='' where A.ParentID=B.PlaceID

Answer 1

Hello,
Welcome to Microsoft Q&A!

In release mode execute much faster than Debug mode. May I know the difference please?

For explaining this problem, please refer to Compile apps with .NET Native document.

.NET Native is a precompilation technology for building and deploying UWP apps. .NET Native is included with Visual Studio 2015 and later versions. It automatically compiles the release version of UWP apps that are written in managed code (C# or Visual Basic) to native code.

For users of your apps, .NET Native offers these advantages: Faster execution times for the majority of apps and scenarios. Faster startup times for the majority of apps and scenarios. Low deployment and update costs. Optimized app memory usage.

And UWP has many outputs in debug model that also reduce performance.

Thank you.

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.