Distance just killed my relationship. Howeever, to her credit, on our second date shorty said she couldn't do distance. We started out without distance, and then my job forced me to locate internationally for six months. She tried her best but eventually succumbed to it, which hurt hard.
I think it depends on the emotional capacities of the woman. My girl didnt have that many friends, which made the strain of not having someone to spend time with more accentuated. The physical temptations are there but with the right woman, it doesnt bother you as much.
I honestly never even considered hooking up with another chick, though its obviously super easy since you have no one there to hold you accountable. Long distance requires such a heightened time investment, though, that you're only doing it because you have manifested an intent to be committed to the other person, else it's not worth the struggle, so in a way the temptation to cheat isnt as strong as you would imagine
It's tough. I will tell you that there is more comforting her emotional needs than in a typical relationship because you have to make amends for the lack of physical interaction. If it's the right girl, then it's not a problem. Just make sure she can handle it.