I have invested in a well known database ans cataloging workflow solution and painfully went through each photo (some 3000) and keyworded them mostly with regards to people and location. I particularly saw the value in typing my daughter's name and all pictures with her in, appearing before my eyes! Likewise I can get pictures with her and her mummy by entering keywords.
I think that I did this partly because the software had it and I thought this could be very powerful. However, I am only an keen amateur (very amateur!)and I do not often have a particular "shoot". My cards may span several weeks with different photo opportunities.
I am wondering whether all this was a waste of time - a now have a highbrid ofvarious file structures and naming conventions in my pictues folder - ie files all over the place. Keywording takes too long - since I often work long hours its hard to keep up.
I also love the result that NX often produces - my best prints have come from this software. I am now looking for a solution that simplifies things. I want to be able to see all my photos quickly.