SQL (SQLite) Technique

  1. Vacuum after deletion
    1. Related links:
      https://www.sqlitetutorial.net/sqlite-vacuum/
    2. Related code:
      e.g., Page: NyuukoKiroku,
      Scenario: Multiple rows deletion
      Location: ZaikoKanri.py > MainDialog > nkDeleteRow_clicked()

      1. Go to Definition
        Location: ZKDB.py > deleteFromShukkoNyuukoKiroku()

        • conn.execute("VACUUM")