What are transaction speed of Microsoft Access & Microsoft SQL

What are transaction speed of Microsoft Access & Microsoft SQL

Post by ZmFpa » Wed, 25 May 2005 02:11:25


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)
 
 
 

What are transaction speed of Microsoft Access & Microsoft SQL

Post by Rick » Wed, 25 May 2005 02:44:42

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.

--
Rick B





will
know
something

of


per
prove
speed?

 
 
 

What are transaction speed of Microsoft Access & Microsoft SQL

Post by Alex White » Wed, 25 May 2005 03:27:42

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.

--
Regards

Alex White MCDBA MCSE
http://www.yqcomputer.com/
 
 
 

What are transaction speed of Microsoft Access & Microsoft SQL

Post by ZmFpa » Thu, 26 May 2005 20:05:05

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?

"Alex White MCDBA MCSE" wrote:

 
 
 

What are transaction speed of Microsoft Access & Microsoft SQL

Post by Alex White » Thu, 26 May 2005 20:42:35

here 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.

--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

"faik" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...