Go Back   Access World Forums > Microsoft Access Discussion > Access Web

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-06-2019, 12:20 AM   #16
sonic8
Newly Registered User
 
Join Date: Oct 2015
Posts: 225
Thanks: 35
Thanked 63 Times in 60 Posts
sonic8 is on a distinguished road
Re: ODBC vs. Sharepoint - which is faster?

Quote:
Originally Posted by NauticalGent View Post
If I understand it correctly MySQL is usually PC based and you are limited to the performance of that PC.
MySQL runs on a wide variety of operating systems and hardware and can even be distributed across multiple computers in a MySQL cluster.


I regards to performance, I don't think there is fundamental difference between MySQL and Microsoft-SQL-Server.

__________________
New article:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
sonic8 is offline   Reply With Quote
The Following User Says Thank You to sonic8 For This Useful Post:
perlfan (02-10-2019)
Old 02-06-2019, 12:27 AM   #17
sonic8
Newly Registered User
 
Join Date: Oct 2015
Posts: 225
Thanks: 35
Thanked 63 Times in 60 Posts
sonic8 is on a distinguished road
Re: ODBC vs. Sharepoint - which is faster?

Quote:
Originally Posted by perlfan View Post
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.
__________________
New article:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
sonic8 is offline   Reply With Quote
The Following User Says Thank You to sonic8 For This Useful Post:
perlfan (02-10-2019)
Old 02-06-2019, 06:25 AM   #18
AccessBlaster
.
 
Join Date: May 2010
Posts: 1,088
Thanks: 24
Thanked 267 Times in 254 Posts
AccessBlaster has a spectacular aura about AccessBlaster has a spectacular aura about
Re: ODBC vs. Sharepoint - which is faster?

Older infrastructure could play a part in transfer rates. Older CAT cable, switches and servers running older versions of SQL / MySQL. Not to mention older individual workstations putting unnecessary traffic or load on the network do to poorly designed queries.

AccessBlaster is online now   Reply With Quote
The Following User Says Thank You to AccessBlaster For This Useful Post:
perlfan (02-10-2019)
Old 02-10-2019, 09:56 PM   #19
perlfan
Newly Registered User
 
Join Date: May 2009
Location: Stuttgart, Germany
Posts: 165
Thanks: 129
Thanked 3 Times in 3 Posts
perlfan is on a distinguished road
Re: ODBC vs. Sharepoint - which is faster?

Thanks for the input. We'll use our frontend with MS SQL Server - as soon as I can compare the performance with MySQL, I'll share this here. Frank

perlfan is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Which one is faster? BlindPro General 1 12-15-2013 07:05 AM
ODBC Call Failed when different ODBC tables are linked with different accounts sharpnova General 5 04-20-2012 08:53 AM
Question What's faster than Access w/ODBC anotherProgrammer General 17 09-22-2010 09:06 AM
Is there a faster and better way? Steven Deetz Modules & VBA 0 08-23-2006 01:01 PM
I need to make this run faster... Abby N Modules & VBA 0 05-15-2001 12:12 PM




All times are GMT -8. The time now is 05:37 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World