Ruthlessness works. Culling the herd is essential if you take a lot of shots. I went to the lakes last year and took over 300 shots of different locations. I imported, deleted the rubbish and just left the rest. I think I was truly happy with maybe a dozen which I "worked" on in post.
I had thousands of photos going back to 2006 which I never looked at. Finding anything was a royal pain, and so I went through and deleted lots of photos. Some I hadn't looked at in almost ten years and was unlikely to do so in the future.
My workflow...
After your day out/shoot/whatever, drop all images into a "bin" folder.
"Add" them in LR - takes less time than importing.
1st pass - delete all the junk (oof etc)
2nd pass. Multi select (ctrl+click) images that are similar or of the same subject and press "n". This takes you into a survey mode/contact sheet. This is where I get ruthless. By seeing all my shots of the same sort of thing, I can find maybe the best 2, or 3, or maybe 4 if it's an outstanding subject. Every photo that doesn't make the cut, I press "x" to reject it. I have a filter set up to remove rejected photos from the view, so it disappears and the remaining images shuffle around to fill the screen. I repeat this for all images from the shoot that are similar. This usually cuts out 50-80% of my photos. (I've written an article about this process
here if you're interested in further reading)
These "rejected" photos are then filtered against and deleted. You could just delete them from the catalogue (if you really think you might go back to them and disk space isn't an issue), or if you're brave, delete them from disk.
The remaining photos are then converted to DNG and moved into a folder using LR. I have an additional step, which involves choosing my absolute best images (zero, one or two from any shoot) and exporting them to a Portfolio catalogue so that when I want to do some PP, I start with portfolio shots. These are my best work.
Lightroom is an amazing photo management tool and it's easy to have a huge catalogue with all your images because you can. Learning to differentiate your best work from the merely average is a really useful skill to learn.