The Access Show: Client performance improvements against SharePoint lists

Download this episode

Download Video

Description

Today’s guest is DJ Cole, architect and primary developer of SharePoint connectivity performance improvements on the Access development team. DJ dropped by to talk about how Access 2010 connects to SharePoint, and to discuss the work necessary for improving client-side performance.

As with most performance work, beauty is in the eye of the user. When users work against a server on the other side of the world, performance makes a difference. Data, after all, only travels as fast as the speed of light. Our goal for Access 2010 was to make the connections to SharePoint lists nearly as fast as local tables. Additionally, we had to ensure requests didn’t swamp the server, bottleneck throughout the network, or cause the client machine’s CPU or RAM to thrash. We found that caching data in local tables, combined with conservative usage of resources on the server, network and local machine, provided the best user experience.

This Access 2010 performance improvement builds upon the Access 2007 architecture. Read more…

For additional information about the latest release, check out the Access 2010 Intro series on the Access team blog.

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    • User profile image
      HD dizi izle

      As with most performance work, beauty is in the eye of the user. When users work against a server on the other side of the world, performance makes a difference
      HD dizi izleDizi izleYabancı Dizi izleHDdiziizle.Org

    • User profile image
      Allan

      TStarted as a student-driven event in 2007 with support from SPARC and the library community, Open Access Day was at first a library-centric affair. Having grown in recognition and participation every year since, in 2010( http://www.btscene.com/search/term/2010/cat/0/ ) we truly began to make deep inroads into the academy.

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.