Thursday, May 24, 2012 4:54 AM
I would like to understand the factors we should consider for deciding whether to go for sharepoint lists or sql tables.
I have already gone through below link:http://msdn.microsoft.com/en-us/library/ff647105.aspx
- Moved by Ed Price - MSFTMicrosoft Employee Friday, June 01, 2012 10:51 PM By request (From:MSDN, TechNet, and Expression Profile and Recognition System Discussions)
Thursday, May 24, 2012 12:17 PM
wrong forum - ask her:
- Proposed As Answer by Naomi NMicrosoft Community Contributor Thursday, May 24, 2012 1:35 PM
Friday, May 25, 2012 2:53 AMI know it is wrong forum, This site was not allowing me to post this in sharepoint forum and i thought the coordinators would help me in this.
Friday, May 25, 2012 7:23 AM
what exactly is your problem. I have tested the "Ask a question" feature. Works fine for me.
Friday, June 01, 2012 10:50 PM
I know it is wrong forum, This site was not allowing me to post this in sharepoint forum and i thought the coordinators would help me in this.
Nilesh, I am moving this question to the SP2010 General forum.
Saturday, June 02, 2012 2:32 AM
Nilesh, can you be a little more specific about what you are wanting to know. The link you have already gone through is what I would have linked if you had not said you had already gone through it.
I would boil it down to...
If you expect to have lots of data (generally more than 2,000 rows) and/or need to do even moderately complex joins between lists/tables and/or need to handle a decent transactional load, use SQL. Otherwise use SharePoint.
Of course, SQL is more complex to use and therefore requires additional expertise. There may be additional cost depending on how your current environment is setup and how you plan to use SQL, if you go that route. Some companies push SharePoint to it's limits for those reasons and try to use SharePoint as much as possible.
Doug Hemminger http://www.sharepointdoug.com
- Marked As Answer by Serge Luca [MVP]MVP Saturday, June 02, 2012 3:13 PM
Saturday, June 02, 2012 3:14 PMIndeed, the link summarizes everything !
Serge Luca; SharePoint MVP ; blog: http://sergeluca.wordpress.com/ Devoteam Belgium. http://twitter.com/sergeluca