I've tried the medication for dementia for about 6 months. Tried two different doses without much effect. He finally figured out that I was giving him pills in his cheese treats, and quit eating them altogether. After failing to find anyway to get him to take the pills I decided to see what would happen if I just quit them. Turns out he actually seemed to improve a bit WITHOUT the medication.
While he was on the medication he would never come up to anyone to be pet; just kind of wandered around oblivious to people in the house. Now that he's off of it, he still paces but will come up top people and let them pet him for a bit before he continues his wandering.