If I want to retrieve large number of records(1 million) from a table
from a big table, what kind of problem would I run into?

Would mysql connection time out? How would the network latency play a
role? For example, I have mysql on another machine1 and application
is running on same network, but on different machine2.

I need someone who has worked on large database and performed such
large simple read sql query to a large table, no joins.

Can someone help?

thanks,
joe