The amount of hosts you are able to connect to for one file depends on your connection speed and whether you have the basic or the pro version of LW.
In your case, assuming that you have DSL/ADSL and the Pro version, you're limited to 10 hosts.
Read here on how to increase your download success:
http://www.gnutellaforums.com/showthread.php?t=17321
Regarding files with hundreds of hosts, stay away from them; they are most likely faked files you'll never be able to download.