I'm getting ready to move all my photos & future workflow to Lightroom, thought I'd put my workflow here so more experienced people could point out any obvious inefficiencies.
I shoot raw, and at the end of the workflow I like to end up with 4 copies of each photo - an archived raw image, an edited & processed PSD, a print resolution jpg, and a screen resolution jpg. I have identical folder structures under these 4 roots where the photos live.
The workflow is:
1) Copy all images into a special "unprocessed" folder under the archive root & import them into lightroom
2) Process them - iteratively refine the keepers and move them into appropriately named folders under the archive root. Create a named collection for each folder. Develop the keepers and keyword them.
3) Export all the new folders created under "archive root" into PSD's in a corresponding new folder created under the "edit root".
4) Run photoshop scripts on the edited files to do things like noise reduction (I use NoiseNinja) for high ISO, and capture sharpening (I use photokit sharpener). Any other special PS editing required.
5) Run photoshop scripts that automatically create print & web versions of the edited file in the right folders after sharpening (using photokit).
6) Import the edit, print & screen folders into the same collection in lightroom that was created in step 2. Use automatic stacking with 0 secs time to automatically stack the 4 versions of the same image together. Attach a "image type" keyword (edit, print, screen) to the imported images appropriately on import.
This should I believe let me end up with a collection for every "shoot", with all versions of the images stacked together, and findable using keywords etc. I also have PSD's that contain all the master information that I can easily backup as files (I'm paranoid and don't like my information salted away in DB's where they can get corrupted).