make caml query easier for joins & list view threshold
join query is complex to retirve in multiple list please provide simple and effiecient way to handling caml queries,
we are facing the threshold limit value for list and library very complex to maintain more than 5000 items, please make its a performance improve
Richard Przybylski commented
Using expiration or a workflow to move old data to another list will help. Also categorizing the data and placing the data in different lists will help in the performance. Using folders is a bad idea. If you have related items to go into a folder in a list (attachments folders) then that is fine. Utilizing controls in your initial workflow can handle where list items or documents can be and should be stored. this will enhance your capabilities and performance. Don't think of lists and libraries like you do your windows explorer. Your computer is used by one person. This is a different situation. Handling your data like a book where chapters are lists and libraries are more like the way you need to build each site.