After you started using SQLite, you got a performance degradation, and as you tried to correct it using WAL in memory changelog, it has become really worse. Especially with respect to API/EAH and other stuff that will just get the committed data and not the delayed in memory data on their queries. This is among the reasons you have several issues, but i am not going to touch them. One example i can give is that right now i positioned a SV in a playfield, and 45 minutes later EAH still lists it as positioned at another location. querying API shows same delayed positional data. What I really want to atleast give server owners a chance to help with some of this stuff, is a simple console command to reconsile memory data to file. (checkpoint as its called in the SQLite world). For example a command like: database commit that triggers SQLite checkpoint In total i would like to see a console command like database with the following sub options: dump - dump the whole db to a copy file size - to list file and in memory size info - over view over number of tables and items, as well as last write to disk My main wish was to get a SQLite = true/false with a corresponding mssql-connstring and mysql-connstring option in config. That way we who have access to better database resources can utilize them.
