First off, I am a fan of Apple's Aperture program, have been using it since V1,0 (had lots of opportunities for improvement then ). Currently it's at V3.3 and it's developed into a mature, feature packed, stable program. I currently have about 110,000 images and videos in multiple referenced libraries, living on DROBO raids, Aperture has no problem tracking, managing, and modifying the images as I see fit.
Recently I received two requests for images, One was a request for a specific rider, in a specific motorcycle race, The 2011' Barbara Fritchie Classic . Easy enough as I only shot around 1200 images at the even. The next request involved one rider, and a whole series of races held by the Baltimore County Trail Riders Association in 2011. A bit tougher as I shot almost 9000 images at the race venues in last year.
Here's how Aperture and more specifically the Smart Albums made the task easy. First pass I looked at the images from the event date in "thumbnail view" which allows very fast scanning of galleries. I then used keyboard command to assign a color tag to all images that met the search requirement. Then I create a smart album based on that color. Paste in the riders name and # in the keyword metadata. Delete the color tags, and redefine the Smart Album criteria to reflect the riders name and number. I then use the Zenfolio export tools to move the requested products to a specific gallery. The Flickr export plugin to post to Flickr so I can post a link to Facebook. I was really surprised how quickly these tasks were accomplished.. Shout out to Apple, keep up the good work, allowing me "to get things done".