Read about how using SharePoint’s SPQuery object can be used to retrieve batches of data instead of retrieving all items of a list. Consider using this option in order to minimize the activity on the database. Its enough to just request the data that you need and its best to let that work done by the database.

http://blog.dynatrace.com/2009/01/15/sharepoint-page-through-sharepoint-lists/

< Prev		Next >