What are transaction speed of Microsoft Access & Microsoft SQL Ser

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to know about the transaction speed and transmission speed of
Microsoft Access & Microsoft SQL Server.
I have found that the transaction speed of SQL is 709,220 transactions per
minute. Is that right? If yes, where can I find any certification to prove
it? Also, how about the transaction speed of Microsoft Access?
If the Microsoft Access & Microsoft SQL Server have transmission speed?

Thank you for you co-operation.
 
Wouldn't this depend on a hundred other factors?

Is the file on a LAN? How many users are accessing the data? What type of
LAN trafffic do you have? How big is a record? What is a transaction?
etc.
 
It is in a LAN.Only 2-3 users are accessing the data.At the finally it will
have 17 sub form.There are only 1000REcords for each sub forms,I don't know
what is the LAN traffic type,it that mean TCP/IP or Mobbus TCP or something
else? The transaction mean one request from client and one reponse from
server.(As i know)
 
I'm not saying you can give us the variables and we can answer your
question. I'm saying there is no way to know this. It will change every
second of every day. When user one is saving a large file to the LAN, user
2 might see slower response. When your database grows, it will change.


There is no way to set a number on this. That is kind of like saying how
fast can you go on a particular road. Depends on traffic, weather
conditions, type of car you are driving, time of day, etc.
 
Sound like someone upstairs wants some facts that they won't understand to
prove a case one way or another, if this is the case the Microsoft website
is the place to go for statistics

The likelihood you will be able to reproduce any of statistics that
Microsoft publish is very small, given the hardware they run the tests on.
 
I understand what you are saying.
But are there have a limitation about the transmission speed?
If the answer is no,then when i use a 4GB CPU,2GB RAM,LAN With 1GB Optical
fibre,only 1 record and 1 user. Therefore,it can be very very fast.Will it
faster than SQL server with the same hardware equipment?
In Fact, I am comparing Microsoft Access & Microft SQL Server which is better.
In the capacity side, i knew the SQL server is greater than Microsoft Access.
How about the speed of Microsoft Access and Microsoft SQL Server with same
hardware equipment?
 
Where the 2 products are different, remembering that Access does different
things to SQL Server, given SQL Server is data store, and Access is a data
store and front-end, Access is very well optimised for the small (1-20) user
installations, with relatively small amounts amounts of data (<1GB although
it will store 2GB), in the small user/small data arena Access is hard to
beat on performance. SQL Server on the other hand can store vast amounts of
data, and have 100's of users, SQL Server is much more robust as a data
store due in part to it's client server model. SQL Server is very well
optimised for searching through vast amounts of data and getting information
quickly, also the other plus point of SQL Server over Access, is Access
requires your network to be in better shape than the equivalent SQL Server
installation as it is far more chatty on the network.

So in answer to your question in the small data/small user systems, you are
not going to see much in it in terms of performance, SQL wins on
scalability/reliability.
 
Back
Top