TheScouter

We are designing a solution (MOSS website + a lot of services) and have two options to store the information, the first is to save them in a custom list under moss, and the second option is to save them in reqular tables in SQL server.

with moss list we can use the search in moss, and the add edit delete options, but what about the performance



Re: SharePoint - General Question and Answers and Discussion MOSS Lists vs SQL Tables

jhgall

From experience, the rendering speed of lists (in your standard AllItems.aspx view) starts to decline at about 2000+ records.

If you have lists that exceed this, I'd make sure I had some filtered views defined which returned fewer results




Re: SharePoint - General Question and Answers and Discussion MOSS Lists vs SQL Tables

jamesqua

As the above poster mentioned, after about 2000 records in a container performance decreases significantly. However, notice I said container and not a list. You can have hundreds of thousands of items in a list as long as they are seperated in folders that each have less than 2000. There is a very good white paper written about this topic here http://go.microsoft.com/fwlink/ LinkId=95450&clcid=0x409