Tech Talk

Permanent link to Ten Grand Ten Grand

Sunday, September 26, 2004
We recently passed the 10,000 mark in our photo database; ten thousand unique images! And the winner is . . .

Time for some statistics:

  • Each image is processed individually, getting metadata saved into a SQL database for full-text searching.
  • Each image is also saved as several smaller, web-friendly sizes, and filed into a categorical file structure.
  • The entire library consists of almost 40,000 files using over 20GB of disk space.
We adopted Antonio, Carmen, and Felix in August 2000, and went digital in January 2001:
  • 1,605 photos pre-2001
  • 2,090 photos in 2001
  • 2,687 photos in 2002
  • 2,132 photos in 2003 (uh, oh, a downturn!)
  • 1,552 photos so far this year
Since 2001, that's about 188 photos a month (or 6 per day) saved images. Usually our saved to throwaway ratio is about 1:3 or 1:4, so we've taken a whole lot more pictures than we're saving (as it should be).

How are we handling this many images? Computers, of course!
  1. New images are moved from the cards into a single folder for processing
  2. Using Windows Explorer, we admire the pictures, deleting the obviously bad ones immediately.
  3. Then, using a web page linked to this folder, each image is loaded, examined for EXIF info, categorized, described, and titled.
  4. When saved, ImageMagick saves multiple file version and autocorrects the image.
  5. The next image in the folder is loaded up, and repeat.
  6. Each image usually takes about 5 seconds to process; more if more description is needed, or if cropping / redeye removal is necessary.
All this is then immediately available for searching, viewing, and remembering! :)

Some more lesser-known facts:
  • 5,570 pictures by David
  • 3,226 pictures by Krista
  • 5,953 pictures with a Powershot G1
  • 1,359 pictures with a Powershot S230
  • 751 movies
  • Our biggest file is a 53MB movie, and the smallest is a 990 byte wavelet image
  • Our tallest image is 9600 pixels high, and the widest is 16,384 pixels across


LaRocque Family