Originally Posted by perlfan
Is accessing and processing of data stored in SharePoint tables really faster? Or is there no difference?
Technically accessing data in SharePoint will be a lot slower
than doing the same in SQL-Server.
However, when using linked SharePoint tables in Access, the data will be cached locally. This creates the impression
of everything being much faster, because the user will mostly observe the speed of the local operation on the cached data only.
SharePoint has lots of limitations in addittion to slower performance (e.g. limit to 10k rows per table/list) when used as a backend database. So I would only recommend it if you actually need the caching mechanism to provide offline capabilities.