473,324 Members | 2,193 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Why is SQL Server faster than Access?

46
I have been told over and over again that a SQL Server back-end is much faster than an Access back-end, and I have absolutely no doubt that it is. I've read many articles and commentary that confirm this. The side-by-side stats of Access and SQL Server are overwhelmingly in favor of SQL Server.

My question is: Why? What did the developers of SQL Server do differently than the developers of Access?

I understand this is a fairly open-ended question but I've struggled to find distinct reasons why it is such a superior method of data management other than "because it's just so much better, look at the stats!"
Jan 29 '10 #1
2 4329
ck9663
2,878 Expert 2GB
It's the way the data are structured, accessed and the entire architecture. If you need detail, check any white paper in Microsoft Website.

Good Luck!!!

~~ CK
Jan 29 '10 #2
Delerna
1,134 Expert 1GB
The simplistic answer is
Access is a personal database solution meant for small to medium size databases with a small user base and able to run on a personal computer. It was designed sufficiently to satisfy that scenario.

SQL server is a multiuser database solution meant for large databases with a large user base therefore far more effort went into maximizing its performance, some of which comes from running it on high end (and expensive) servers, in order for it to cope with that many users and that much data.

Quality assurance is all about making your product good enough to satisfy its purpose and no more. This is not to say that Access is an inferior product because it is not. Used in the context of what it is meant for it is a great product that is perfectly capable of delivering satisfactory performance.

As your data and/or your user base grows then it makes more and more sense to invest in a high performance database such as SQL Server.



What did the developers of SQL Server do differently than the developers of Access?
I understand this is a fairly open-ended question but I've struggled to find distinct reasons why it is such a superior method of data management other than "because it's just so much better, look at the stats!"
Microsoft aren't going to give away their secrets to their competitors.
They will only give enough info to prove their argument and in the end, the exact "how?"
doesn't really matter.
Jan 31 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Andreas Lauffer | last post by:
Can anyone tell me advantages / disadvantages of DataDirect Server Wire ODBC-driver? Any experiences? What about redistribution? Andreas Lauffer, easySoft. GmbH, Germany
29
by: Mark B | last post by:
We have an Access app (quite big) at www.orbisoft.com/download. We have had requests by potential users to have it converted to an SQL version for them since there corporate policy excludes them...
4
by: neptune | last post by:
I've been reading the numerous posts on using SQL Server vs. Access, but still don't know if SQL server is right for my applications. I work in a section of a large corporate accounting department...
1
by: Kamyk | last post by:
Hello all! I have such question to all of you. I have some tables linked from MS SQL Server 2000. Is time of processing query based on these linked tables from MS SQL Server 2000, faster or...
29
by: Jan | last post by:
Hi: I have an Access database that's been running (in one form or another) for a couple of different clients for a few years. Now a new client has requested that it be implemented with a SQL...
3
by: dm1608 | last post by:
I have an Ecommerce application that uses mostly ASP and a bit of ASP.NET. Monitoring the servers memory via SNMP every 5 minutes would indicate that there is a memory leak somewhere within the...
9
by: billmiami2 | last post by:
I was playing around with the new SQL 2005 CLR functionality and remembered this discussion that I had with Erland Sommarskog concerning performance of scalar UDFs some time ago (See "Calling...
20
by: TC | last post by:
I need an automated procedure to copy data from an Access table to a SQL Server table. Speed is important. What is the recommended technique? I can export the data from Access, copy it via FTP,...
13
by: SQL Learner | last post by:
Hi, I have a table with 8 millions records. Some of the fields needed to be parse and modified. Example, "ABC DEF" will be parsed into two fields "ABC" and "DEF". And If there is "123" in the...
18
by: maxhugen | last post by:
I have an Access app (split into FE and BE) running for some years, that is now also being used in a second office, connected by a WAN. This office has network problems, as it's over-utilized (97%...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.