The bit rate is indirectly proportionate to the quality of the footage. Meaning, if you have motion in the shot, the bit rate will affect the quality depending on the amount of pixel change there is frame to frame. If you had a still shot, with no movement, the bit rate could be as low as the DVD standard will allow, because it only has to render the frame once, and that will persist. Video compression has everything to do with the pixels on the screen, not the length of the video.
That being said, taking all things into account, you set your bit rate depending on the movement in the frame compared to the length of the video, knowing that you can't have a total bit rate higher than 10.08 Mb/s. If your video is less than an hour, you can max out your vid bit rate. If it's longer than 2 hours, you'll have to decide what is more important: having the entire movie on a single DVD, or having it playback at a higher quality.
SHort answer, you could go as low as 2 Mb/s in Compressor which will get you close to 3 hours on a DVD, but if you so much as turn your head it will be very ugly. You might get by with just blinking.