Suggested SQLite3 DB Optimizations

[ChuckPa]

Here is my tool.

1. Stop PMS
2. Run as root
3. If you want the most expedient, I recommend actions:

• Check
• Repair
• Reindex

4. If you want to examine the individual facets,

• Check
  – ls -la the database sizes before starting
• Vacuum
  – Now ls -la of the databases again
• Reindex
  – One last check

Feel free to check the DB sizes between each step.

The only conflict possible is if PMS is running and you attempt to use the tool AFTER PMS starts.

This tool only checks for PMS at first startup so be careful.

DBRepair.tar (40 KB)

I typically see problems with PMS when:

1. There is small, but non-fatal, database damage
2. The WAL & SHM files do not fold back into the main DB at PMS exit (which it ALWAYS should)

NOTE:

I’ve added an extra couple checks based on feedback received.
Please let me know if you get errors before getting to the main menu.

15-Oct-2022

Restructured Docker test.