Rapid
 Interactive
  Programming
   Environment

Maintenance
! under construction !

There are two types of maintenance that can be a carried out on a database.

  • Housekeeping - the focus is on removing entries that are not correctly linked inside the database

and

  • Synchronisation of entries with changes made in the file system. This activity results in the slave part of the database being over-written.
  • No problem. Either:
    • Do not keep anything important in the slave part.
    or:
    • Create a back-up of the original database with another file name.
    • Do the maintenance actions
    • Then import the slave part from the back-up database.


Housekeeping

The housekeeping activities are shown in the following menu screenshot.


Remove unreferenced devices

Dup Finder will remove any unreferenced entries in the master, and in the slave, device tables.


Compress database

In normal usage a SQLite database only grows i.e. occupies more and more storgae space. Even when entries are deleted the physical storage space is not released.

This command will cause Dup Finder to release the unneedesd storage space.

Technical note: It uses the SQLite Vacuum command.


Remove paths that have no files

Dup Finder will remove any entry in the master and in the slave path tables that are not referenced by a file entry.


Remove files that have no paths

Dup Finder will remove any entry in the master and in the slave file tables that do not reference by a path entry.


Enter maintenance mode

This option will give you access to the synchronisation maintenance options, remember these will overwrite the slave part of the database.


Mark: paths with no files

Clears the duplicate status for all entries in the master and in the slave path tables. Then it identifies paths entries that are not referenced by a file entry, all unreferenced paths are then marked as “duplicate”.

This action over-writes the duplicate status of all path table entries.


Mark: files with no path

Clears the duplicate status for all entries in the master and in the slave file tables. Then it identifies file entries that do not reference a valid path entry, all such files are then marked as “duplicate”.

This action over-writes the duplicate status of all file table entries.


Synchronisation

I am lazy.

Sometime I know that my reference disk, or archive folders, have been modified and that I have not kept the relevant database file “up-to-date”.

Well. I could just create a new database file and rescan everything, but that seems a poor solution. So I have built in a mechanism to allow me to update a database without rescanning everthing.

BUT: the requirement is that the slave part of the database is overwritten.

No problem. Either:

  • Do not keep anything important in the slave part.

or:

  • Create a back-up of the original database with another file name.
  • Do the maintenance actions
  • Then import the slave part from the back-up database.


To enter the synchronisation mode you must activate the menu option:

Enter maintenance mode

This option will give you access to the synchronisation maintenance options, remember these will overwrite the slave part of the database.

You will be asked to confirm the action.

If you confirm then the standard Dup Finder window will disappear and the cancel dialogue will appear.


Dup Finder will now scan the entire device for each device referenced in the master table, the results will be placed in the slave table.

 

Do not panic!

The scan does not open any of the files, nor does it create a hash check sum.

A complete 2 T byte disk scan is completed in about 5 minutes.

 

Finding changed files:

When the scan is finished the cancel dialogue will disappear, and the normal Dup Finder window reappears. The maintenance menu will now offer extra options:


Finding changed files:

The scan includes the last modified date for a file. So we can now compare the last modified dates for a file in both the master and the slave. If the dates are not the same the file entry’s duplicate status is set.

 

! under construction !

[Home] [Uses] [History] [Goals] [First Steps] [Displaying Entries] [Display Filters] [Scan Filters] [Import Export] [Finding Duplicates] [Removable Storage] [Maintenance] [FAQ]