In case you switch to Linux, you can use Fotoxx, that one is fairly good at handling large collections.
i don't want to sync up the photos anywhere near the internet
is this your meme collection?
i need to cleanse my life
no it is my real life photos
Why are you here then? If your life gives you enough opportunities to take 100000 photos then you're wasting your time on a *chan.