Working with large lists in Office SharePoint Server 2007

Microsoft published a very interresting white paper about working with large lists in moss:
http://technet.microsoft.com/en-us/library/cc262813.aspx
This white paper compare performance of differents methods that are used when working with SPList:

• SPList with For/Each
• SPList with SPQuery
• SPList with DataTable
• SPListItems with DataTable
• Lists Web service

The results show that using SPQuery with indexed columns are recommended to improve performance of retriewing datas from large Sharepoint List.