While, everything that Suzy says is true, a direct answer to your question is "immediately". As soon as your FTP transfer completes, your files are available to the internet, from your web site. But, that assumes that everything else about your domain and hosting are in place properly. So I don't think that FTP transfer and update times are your problem.

According to an InterNic search, your domain has been around for a while. But your Name Servers appear to be pointing to a "parking" web site. This sometimes happens if you let your domain name rent lapse. When you reinstate it, with an infusion of money, the Name Servers may need to be reset. If you have hosting with Bravenet, you need to log into your domain manager and set the Primary and Secondary Name Servers, to the servers provided by Bravenet.

Domain Name: RALLYPHOTOS.COM
Name Server: WEB1.DOMAINCHECK.CO.UK
Name Server: MANAGER.DOMAINCHECK.CO.UK

If you don't have the name of the Bravent servers for your web site, contact Bravenet directly. They will need to set up their DNS. The whole process could take 24 to 72 hours for all domain servers to expire their existing information and update.