Should be instantly, assuming you are not waiting for a DNS propagation change. You need to tell us more about what you uploaded and where you uploaded it? Domain name? Folder? Application such as Wordpress or something else like phpbb?
If you load the site, what are you seeing? Is it a Dreamhost quickstart page? If so perhaps you loaded your site to a folder but are navigating to the root of the domain?