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?





CodedColor PhotoStudio © 2023 1STEIN GmbH

CodedColor PhotoStudio by 1STEIN is an award-winning 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, stich panoramas, convert RAW photos (from Canon, Nikon, Olympus, etc. cameras), burn digital watermarks, correct colors, batch convert and correct images and generate a web album in HTML5. The software is easier to use than Photoshop, but more versatile than ACDSee, Picasa, Irfanview or Gimp. Many magazines consider it to be the Swiss Knife of Image Editing. Have a look at our Before / After tutorials to get an idea of the powerful capabilities. The software comes with a detailed handbook and a fast database to store EXIF/IPTC data and color information. CodedColor PhotoStudio is the ideal image editing tool for every-day and professional digital camera users. The user friendly interface combines features like expert photo editing & printing, layer editing, web album galleries, slide shows, photo management & cataloging, custom sorting, IPTC & EXIF editor, GPS tagging, perspective correction, barrel distortion, effects, thumbnail generation, resize & resample images, batch conversion, database keyword searching, red eye removal, color/sharpness/brightness & contrast correction, artifact removal, clone brush, scanner & TWAIN import, screen capture, lossless JPEG rotation, transparency (alpha channel) and layers, gamma correction, screen shows 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, photo sharing, etc. Opens and converts all common image formats: BMP, WMF, GIF, JPEG, JPEG2000, TIFF, PCX, PNG, PSP, PSD, PCD, HEIC, HEIF, AVIF and all current RAW formats. The installation includes our the CodedColor Publisher, a versatile photo layout and DTP tool to create individual and rich photo books.