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 2 cleanup modes are provided:
 
Conservative Scan (default)  
Only removes broken links with no relevant infomation or thumbnail. Records with thumbs are kept in the database for reference or later correction, no matter if they are located on connected or unmounted drives.  
 
Deep Scan  
Also removes broken links on connected drives. Only records with thumbs pointing to disconnected drives or unmounted CDs are kept in the database for reference, i.e. whenever the drive or CD may become connected again.  

Note: Both scans keep those broken links in the database, that have a high probability of being automatically fixed again by CodedColor at a later time, or 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.

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?  

2004 © 1STEIN GmbH - CodedColor

CodedColor PhotoStudio by 1STEIN is a powerful and versatile photo organizer and image editing software for digital camera users. Features include photo editing & printing, web album galleries, slide shows, photo management & cataloging, custom sorting, IPTC & EXIF display, thumbnail generation, resize & resample images, jp2000, batch conversion, database keyword searching, red eye removal, color / sharpness / brightness & contrast correction, artefacts removal, clone brush, scanner & TWAIN import, screen capture, lossless JPEG rotation, gamma correction and screenshows with transition effects, panorama stitch, RAW, photo books and layouts, collages, histograms, white balance, PDF export, watermarks, etc. Please visit the CodedColor FotoStudio homepage to learn more or download a free copy!