question

KirankumarMaharana-1019 avatar image
0 Votes"
KirankumarMaharana-1019 asked NicoZhu-MSFT answered

Regarding query execution time in Visual studio and SQLite browser

Hi Team,

one update query execution time in SQLite browser is 59432ms.
150546-sqlitetime.png


In Visual studio same query execution time is 396114ms.
150547-vs-time.png



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




windows-uwpdotnet-sqlite
sqlitetime.png (3.1 KiB)
vs-time.png (4.9 KiB)
· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Which platform that you have used, is it UWP or general desktop app?

0 Votes 0 ·

Hi NicoZhu

Thanks for the replay,

I have used in UWP application

0 Votes 0 ·
NicoZhu-MSFT avatar image NicoZhu-MSFT KirankumarMaharana-1019 ·

What about release mode, Do they take the same time?

0 Votes 0 ·
Show more comments

1 Answer

NicoZhu-MSFT avatar image
0 Votes"
NicoZhu-MSFT answered

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.