If you go to (domain_name)/index.php
does the page load? If this works I would suggest looking at your .htaccess file (supposing your server runs Apache), making sure it was copied correctly and nothing needs to be changed.
UPDATE: Since you say your page does finally load but after a crazy number of seconds, I recommend you try the following steps to troubleshoot your issue.
- Install EE Debug Toolbar;
- In the control panel, go to Admin>System Administration>Output and Debugging and turn on "Display Template Debugging?";
- Reload your front end page (while still logged in to the control panel as super admin);
- Use EE Debug Toolbar to identify any pain-points. The toolbar will show you the total template rendering time in the fifth box, and query execution time in the last box. Clicking on either will give you more detail.
EE Debug Toolbar's GitHub readme page gives you a high level idea of what the toolbar looks like and how it works.
Try these steps, see if it doesn't point out anything obvious to you, and if you have more symptoms but no answers, update your question so we can troubleshoot further. Best of luck!