Topic: Creating a custom search index?
Basically I have a directory of images that have tags in their comments metadata field. I need to be able to search through these tags, but opening and parsing the tags for every image is too slow. So I thought I could create a database table as a sort of index, it would basically be two fields, tag and image location. This seems like it would work fine, but then I realized for it to be fast, I would probably have to add a database index on that table. This seems a little clunky, and would basically duplicate the entire table.
Does anyone have a better idea? Would it be worth it to research hashing algorithms and come up with my own solution?