Hi, We had a Custom List (MOSS 2007 SP1) for a project here and now the size has grown to around 5 GB. It has 20K + rows with attachments. What are the recommended approach to improve the performance of this List. I wanted some solution quickly and I tried to take a backup of this List using SP Content Deployment utility. It gave lots of cmp files when I exported this List and it was like 4.5 GB. My plan was to import this on to a new list and delete rows based on date and create custom Views so that the number of rows displayed is less. But importing this data in to a new Custom List created with same template did not work using SP content deployment wizard tool. The tool just froze after some time. What else can I do in this situation? Regards, Manoj

You should organize item in folder (or filtered view) so that you have a maximum of 2k item by folder(view)....this should be ok for the performance... For the importation... maybe you could use custom code user sharepoint content deployment and migration API... look at this article... http://blogs.technet.com/stefan_gossner/archive/2007/08/30/deep-dive-into-the-sharepoint-content-deployment-and-migration-api-part-1.aspx

Did you check this Blog Post? Scaling to Extremely Large Lists and Performant Access Methods http://blogs.msdn.com/sharepoint/archive/2007/07/25/scaling-large-lists.aspxThanks & Regards, Kamlesh | Blog | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.

Hi, Thanks all for your response. I tried from Site Content and Structure and I could copy and move List items with attachments to another List. I'll currently move out lots of list items based on certain conditions to multiple lists. Now on we'll keep in mind the recommendations regarding no of items and size while using Lists. Regards, Manoj