The Access Show: Client performance improvements against SharePoint lists

Posted By: tina10 | Feb 5th @ 2:46 PM | 37,429 Views | 1 Comment
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.
Rating:
0
0
#Aug 6th @ 2:58 AM
Viola
Viola

It is very nice of them to pay attention not only to the quality but also to speed (I love the song Speed by Bond, downloaded it from music SE http://www.mp3hounddog.com ).  Nowadays almost all new versions of the programs need more and more RAM . I'm glad the team makes essential improvements in Access.

Microsoft Communities