The Access Show: Client performance improvements against SharePoint lists

  • Posted: Feb 05, 2010 at 2:46 PM
  • By: Tina
  • Avg Rating: 0

  • 40,065 Views
  • 2 Comments

Download

Right click “Save as…”

Embed code for this video

Copy the code above to embed our video on your website/blog.

Close

Video format

Note: These selections will fall back to the next best format depending upon browser capability.

Close
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.

Tags:

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.