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?  

2010 © 1STEIN GmbH - CodedColor

CodedColor PhotoStudio by 1STEIN is a Windows photo viewer and editor to organize, edit, resize, reformat, correct, compare, sort, watermark, annotate and print digital images, and to edit EXIF and IPTC data in digital photos. You can rename multiple images, remove scratches, create panorama pictures (stitch), convert RAW photos (from Canon, Nikon, Olympus, etc. cameras), send images via Skype, send photo SMS, burn digital watermarks, correct colors, run a screenshow, convert and correct JPEG images in a batch process, rename fields, open pictures and image folders from the Explorer, generate a webalbum in HTML and compress JPG images. The CodedColor full version is not free, but during registration you can choose the Freeware edition, in which some functions are deactivated. After the download you can try the PhotoStudio shareware for 30 days without any restrictions. The CodedColor software interface looks very similar to ACDSee, is easier to use than Photoshop and more versatile than Picasa and Irfanview, but still contains editing and correction features as effective as Paintshop. Have a look at our Before / After tutorials, in order to get an idea of the powerful editor capabilities. The software comes with a detailed handbook and a fast database to store EXIF / IPTC data and color informationen. CodedColor PhotoStudio is a powerful and versatile photo organizer and image editing software for digital camera users. The user friendly interface includes features like photo editing & printing, web & flash album galleries, slide shows, photo management & cataloging, custom sorting, IPTC & EXIF editor and display, GPS tagging, perspective correction, barrel distortion, effects, 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, transparency (alpha channel), gamma correction, print ordering and screenshows with many transition effects, watermark text, image annotations, panorama stitch & animation, video capture, PDF album export, photo layouts, collages, frames, shadows, histograms, automatic white balance, skype photo sharing, etc. Opens and converts all common image formats: BMP, WMF, GIF, JPEG, JPEG2000, TIFF, PCX, PNG, PSP, PSD, PCD, and all current RAW formats. Visit the CodedColor FotoStudio homepage to learn more and download a free copy! Includes BYNGO MMS messenger and CodedColor Publisher, a versatile photo layout and DTP tool, from which you can order individual photobooks through KODAK.