SQL (SQLite) Technique
- Vacuum after deletion
- Related links:
https://www.sqlitetutorial.net/sqlite-vacuum/ - Related code:
e.g., Page: NyuukoKiroku,
Scenario: Multiple rows deletion
Location: ZaikoKanri.py > MainDialog > nkDeleteRow_clicked()- Go to Definition
Location: ZKDB.py > deleteFromShukkoNyuukoKiroku()-
conn.execute("VACUUM")
-
- Go to Definition
- Related links: