How do you get two hours of video on a DVD with DVD Architect Studio? What compression level do I have to set to get this and is it any good afterwards?
For two hours of video, you'll probably be encoding somewhere around 4500 to 5000kbits/sec, and, if your source video was good, your end result should also look quite good.
Here's a link to an online bitrate calculator that I frequently use for preparing projects that I burn with DVDA2: