You should consider a few things, then:
1) limit the information retrieved to the bare minimum of information that the user needs to identify what they're looking for.
2) use "paging"
the 1st item is pretty self-explanatory - if each row is a bunch of information, then just display the key information on the list page, and provide a link that does another query to get the full information and show that on a subsequent page.
For the 2nd item, look into mySQL's LIMIT keyword - you can limit the results returned from the database by saying
which means, return 15 rows starting from row 10 (rows 10-24). So if you build the view such that a user can page through information X number of rows at a time, you won't have to worry about retrieving everything at once.