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
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.
For additional information about the latest release, check out the Access 2010 Intro series on the Access team