understanding of resource utilization

In web applications, displaying a large list is a tricky subject by itself. For example, a text search may yield 100,000 results, which we need to display in series of pages, 100 results each page.

I want to knw that :

1) What are the available methods/strategies for presenting such large result sets for user to browse through using a web application

2) How do they work (in general)

3) What are their pros and cons?

4) Which is your preference?

Examples of strategies include 1) Break results into pages by loading everything in memory, and then selecting range of records from memory.

2) Using database temporary tables to hold pageable results

3) Make use of database range selection function in selects

4) Others