December 2016 – shogarth.com

SQLite Optimizations: Query Planning

December 5, 2016 Stephen Comments 0 Comment

If a query is running really slowly in SQLite immediately after you have performed a large number of inserts, the query optimizer may be out of sync. If you run the ANALYZE command, SQLite calculate a bunch of statistics about your tables which the query analyzer can then use to optimize further queries. It can be an expensive command to run, but you can more than make up for it with improved query performance afterwards. If you want to check…

Custom Debug Visualizers

December 5, 2016 Stephen Comments 0 Comment

When working with custom data structures, the debugger can show too much information layered through how you’ve constructed it. To make it easier to debug, you can create a custom visualizer which will present only the information you want, to make it easier to debug. Here’s an example of a custom *.natvis file: Let’s look at a few elements here: If you’re using a previous version of Visual Studio, you’ll need to modify your autoexp.dat file to achieve the same…