About eight months ago I was assigned the task of coming up with a solution on how to store 100,000+ JPEG's and provide easy viewing/changing of the information. I had a (250GB) SATA drive installed in the client's server, put in a Gig switch, network cards to match, got them to get three Xerox autofeeding scanners to scan the images of the documents, and setup seven workstations with Picasa to manage the images. The three stations with the attached scanners use Paperport to scan the images into one of seven folders on the server's drive. The employee in charge of that folder then opens Picasa, rotates, renames the document according to account code, and then moves the files from their folder into the main folder of images.
The images in that main folder now number 105,284 images. Some of the problems they've run into is that they can no longer save changes in Picasa without the program locking up. Sometimes when they make changes ghosts of the images hang around. Some times when they make changes it takes closing/reopening the program several times in order to reflect. Overall it's not a bad solution and from the years I've messed around with programs that manage photos Picasa is my favorite; however, I don't believe it's appropriately used in this scenario.
Does anyone have experience in this, know of corporate programs that handle this, or have any suggestions?
Thanks in advance!