Working with lists in Sharepoint 2007

Hi folks,

i've come over an interesting white paper for querying data from sharepoint lists.
Different access-methods are explained (spquery, search, foreach,...).

Very Interesting is the well-known virtual limit with 2000 items per container (list/folder).
The document stands out, that this is "only" rlevant when viewing data with the default sharepoint ui in the browser.
If you plan to put an alternative ui on top of that, you're fine.

Here the link: http://technet.microsoft.com/en-us/library/cc262813.aspx
(There are also other white papers for capacity planning etc.)

happy querying ...