locked
is storing and retrieving huge data in sql server 2008 faster in sharepoint than .net windows application?? RRS feed

  • Question

  • Hi all

    i have a windows .net application developed using .net 1.1 and visual studio .net 2002. It is used to store huge company details in the database (sql server 2008). This windows application is very slow  
    1) while trying to view data in a grid view (data is pulled from sql server 2008)
    2) While trying to view data in crystal report

    My manager is trying to convert this windows application to sharepoint application. My question is will converting this application to sharepoint application improve any performance or increate a speed of pulling the data from database to report or grid view or excell??
    Tuesday, July 10, 2012 7:53 PM

All replies

  • No.  Since data stored in SharePoint is still stored in SQL it should be about the same, unless the older app was poorly written.

    Paul Stork SharePoint Server
    MVP Senior Solutions Architect: BlueChip Consulting Group
    Blog: http://dontpapanic.com/blog
    Twitter: Follow @pstork
    Please remember to mark your question as "answered" if this solves your problem.

    Tuesday, July 10, 2012 8:09 PM
  • If your goal is to improve performance then I would look into using Remote Blob Storage (RBS) when you make the shift to SharePoint.  This is available with SQL server 2008 and SharePoint 2010. Refer to article http://technet.microsoft.com/en-us/library/ee748638.aspx for information on this topic.

    Additionally there are third party solutions available that enhance the RBS features.  This way SQL server does not have to constantly serialize your files to binary and stream it back out.  Instead it will stream it right of the file system, which is must faster. 

    Note:The benefits of RBS are notable when dealing with large files.  For smaller files it might not show any performance improvements and sometimes might perform worse than SQL storage. 

    Anand


    Tuesday, July 10, 2012 9:57 PM
  • Hi froodien1,

    The data stored in my sql server is in terms of tables and columns. there are no huge file (single huge files) but huge small data related to customers in tables.

    so in this case performance will not be better when i convert that same windows .net application to sharepoint application right???

    Thursday, July 12, 2012 6:43 AM
  • Correct.  RBS is only useful for storing the digital image of files that are in document libraries seperate from the main SQL storage.  It wouldn't have any value for storing data.

    Paul Stork SharePoint Server
    MVP Senior Solutions Architect: BlueChip Consulting Group
    Blog: http://dontpapanic.com/blog
    Twitter: Follow @pstork
    Please remember to mark your question as "answered" if this solves your problem.

    Thursday, July 12, 2012 10:22 AM