The Default Standard Template using Video Studio 9 assumes that your video is one hour long.
Using a bit rate of 8000 kbps will produce a file approximately 4.3 Gb.

Video Studio 9
Share--Create Video File--Pal Dvd (4:3) shows the following template.

MPEG files
24 Bits, 720 x 576, 25 fps
Lower Field First
(DVD-PAL), 4:3
Video data rate: Variable (Max. 8000 kbps)
LPCM Audio, 48000 Hz, Stereo

Rendered the video using lower bit rates will reduce the file size.
This allows us to fit longer videos to a standard DVD.

The audio properties also contribute to the file size.
LPCM Audio using more memory than Mpeg Audio and Digital Dolby.

I decided to use a 6 minute video during the tests.
The following template was used throughout, changing only the Bit Rate and Audio.

MPEG files
24 Bits, 720 x 576, 25 fps
Lower Field First
(DVD-PAL), 4:3
Video data rate: 8000 kbps (constant or variable)
Audio data rate: 256 kbps
Dolby Digital Audio, 48 KHz, 2/0(L,R) or (LPCM)
.

Ntsc
8000 Constant -Lpcm Audio

The times in the right column are the maximum you can achieve.
Keeping just below these figures will ensure you create a file under 4.3 Gb.
Enabling you to fit to disc without further rendering.

A guide to quality:-

Top quality dvd use 8000 kbps (up to 60 minutes)
Very good quality use 6000 kbps (up to 90 minutes)
VHS good quality use 4000 kbps (up to 120 minutes)

I find it best to create my own templates using 'Tools-Make Movie Manager'