Database Maintenance
Top  Previous  Next


Cleanup database

The CodedColor database consists of a set of files found in the Workdirectory\Data folder. The only maintenance that should be applied to the database is the menuitem Cleanup database. This feature is NOT a binary compression like that of Microsoft Access, but rather a removal option for obsolete image records and broken links. The function removes only those records, that hold no relevant user information and don't seem to belong to any physical image file on your harddrives, thus compressing the database and speeding up CodedColor in general.

The following 3 cleanup modes are provided:
 
Conservative Scan (default)  
 
Only remove broken links with no relevant information or thumbnail. Orphaned records with thumbs or annotations are kept in the database for reference or later correction.  
 
Typical Scan  
 
Remove broken links on connected drives. Orphaned records on disconnected drives or unmounted CDs are only kept in the database for reference, if they have an associated thumb.  
 
Deep Scan  
 
Remove broken links on connected/disconnected drives or unmounted CDs. If you later remount a drive or CD, then the records and thumbs will be added again to the database.  

Note: The conservative and typical scans keep those broken links in the database, that have a certain probability of being automatically corrected by CodedColor at a later time, i.e. if they are pointing to temporarily disconnected drives or unmounted CDs. So doing regular cleanups in either case does not lead to any information loss. But even the deep scan is not really dangerous, as all EXIF/IPTC image descriptions are stored in the image files as well.

Enable Update Creation time from EXIF data, if you want to overwrite empty OrgDate values in the database with the corresponding EXIF image creation date. This is recommended if you intend to use the Timeline feature. This feature depends on the OrgDate (original creation date) field.

icon_tip Related topics

·Backup database  
·How do you handle broken links?  
·What's the difference between file date and photo date?