MP2-445: SQLiteDatabase - perform ANALYZE on the database after the completion of every ImportJob (client and server); Gives us a performance boost on GroupValueGroups calls in the MediaLibrary (and also speed improvements for other commands)
MP2-445: Temporarily solved a strange sql query generated by Media.LoadItem caused by calling it without any necessary or optional requested MIAs. This is a temporary workaround. The problem needs to be solved in MainQueryBuilder.
MP2-445: Added missing reference to System.Threading.Tasks.Dataflow in SQLiteDatabase.csproj
MP2-445: Updated system.data.SQLite to version 1.0.93.0, added .gitignore and amended SQLiteDatabase.csproj and build.targets to avoid committing binaries to nuget
MP2-445: Resolved a bug in MediaLibrary introduced by the change to LoadItem (forgot to check for null reference)
MP2-445: Solved a bug in LoggingDbCommandWrapper where it logged wrong performance data on long running queries; improved precision of performance measurement by using StopWatch instead of DateTime.Now; also logging two fractional digits of milliseconds now.
MP2-445: Added support for the new ChunkSize setting (default: 16MB) for speed increase on regular harddrives (non-SSD)
MP2-445: SQLiteDatabase: Corrected wrong logging of SQLiteSettings
MP2-445: SQLiteDatabase: Introduce SQLiteSettings.EnableDebugLogging to enable and disable SQLDebugLog (default for DEBUG builds is enabled, for RELEASE builds disabled);
Improved logging of SQLite information in general
MP2-445: SQLiteDatabase: Improve SQLiteSettings; remove InitializationCommand and replace it by individual settings for each option
MP2-445: Changed indexed property of n:m attributes in all MIAs to true - results in speed improvement for fresh imports