Re-indexing the SQLite database

If instructed by PathSolutions support, you may be requested to reindex your SQLite database. This is the procedure to do that:

  1. Stop the TotalView service
  2. Open a CMD line
  3. Change directory to the C:\Program Files (x86)\PathSolutions\TotalView\Data directory
  4. Run: sqlite3 SwMonitor.db
  5. At the “sqlite>” prompt, enter: REINDEX;
  6. This reindex may take up to 20 minutes based on the size of the database
  7. At the “sqlite>” prompt, enter: .quit
  8. Start the TotalView service