Speed of different Access-Versions

  • Thread starter Thread starter harmi
  • Start date Start date
H

harmi

HI NG,
how is the differenence in speed of the A2???-Versions compared to
A97.
thanks for helping
Reiner
 
If all elements are the same (CPU, RAM, etc.) Access 97 is noticeably
faster. I can open a 25 MB database in A97 in well under a second.
 
If all elements are the same (CPU, RAM, etc.) Access 97 is noticeably
faster. I can open a 25 MB database in A97 in well under a second.
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com






- Zitierten Text anzeigen -
Click to expand...

Hi Arvin,
thanks for your support.
is it true, that all the Access-Version after A97 are slower?
(always based on the fact, that the conditions machine etc. are the
same)
If it is so, are there any percentages or factors that can be said.
means f.e. A2000 is half as fast as A97
regards
Reiner
 
But speed of opening is only one of many possible criteria for measuring
database performance.
This also depends on the size of the database.
Later versions support larger databases and CPUs are getting faster all the
time.
In my opinion, if you are overly worried about speed, Access is the wrong
database for you.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
m:
If it is so, are there any percentages or factors that can be
said. means f.e. A2000 is half as fast as A97
Click to expand...

While at the time A2000 was introduced it was noticeably slower,
hardware has advanced so much that it no longer feels slow. Remember
that in mid-1999, a 500-600MHz PC was considered fast!

I find A2003 to be completely satisfactory on all the hardware I
use, which is almost all behind the times. A2007 is usable, but I
haven't done anything significant with it yet, so can't really say.
Many people have reported it to be very, very slow, and I have read
that Office 2010 requires even more in terms of performance. On the
other hand, that observation is based on beta versions of 2010, so
the performance requirements may change drastically. Certainly
Windows 7 performs better than Vista (and some say better than
WinXP), so 2010 may not increase system requirements as we've come
to expect with new Office versions.
 
harmi said:
Hi Arvin,
thanks for your support.
is it true, that all the Access-Version after A97 are slower?
(always based on the fact, that the conditions machine etc. are the
same)
If it is so, are there any percentages or factors that can be said.
means f.e. A2000 is half as fast as A97
regards
Reiner
Click to expand...

I am only talking about time to open. Yes Access 2000 is noticeably slower,
and some later versions even more so. We're still only talking about 2
seconds instead of 1. If we were talking about minutes, there may be
something to worry about.
 
Dorian said:
But speed of opening is only one of many possible criteria for measuring
database performance.
This also depends on the size of the database.
Later versions support larger databases and CPUs are getting faster all
the
time.
Click to expand...

All of that is true.
In my opinion, if you are overly worried about speed, Access is the wrong
database for you.
Click to expand...

Access, is one of, if not the fastest database on comparable hardware. Some
server based databases if altered so the logging is not done are faster, but
that's mostly because they run on dedicated servers. Given a gigabit network
and high powered machines, there's little difference on the size of
databases usually run on desktop machines.
 
Back
Top