A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Speed of different Access-Versions



 
 
Thread Tools Display Modes
  #1  
Old February 3rd, 2010, 09:27 AM posted to microsoft.public.access.forms
harmi
external usenet poster
 
Posts: 20
Default Speed of different Access-Versions

HI NG,
how is the differenence in speed of the A2???-Versions compared to
A97.
thanks for helping
Reiner
  #2  
Old February 3rd, 2010, 12:49 PM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Speed of different Access-Versions

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, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"harmi" wrote in message
...
HI NG,
how is the differenence in speed of the A2???-Versions compared to
A97.
thanks for helping
Reiner



  #3  
Old February 3rd, 2010, 03:29 PM posted to microsoft.public.access.forms
harmi
external usenet poster
 
Posts: 20
Default Speed of different Access-Versions

On 3 Feb., 13:49, "Arvin Meyer [MVP]" wrote:
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

"harmi" wrote in message

...



HI NG,
how is the differenence in speed of the A2???-Versions compared to
A97.
thanks for helping
Reiner- Zitierten Text ausblenden -


- Zitierten Text anzeigen -


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
  #4  
Old February 3rd, 2010, 11:40 PM posted to microsoft.public.access.forms
Dorian
external usenet poster
 
Posts: 542
Default Speed of different Access-Versions

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


"Arvin Meyer [MVP]" wrote:

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, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"harmi" wrote in message
...
HI NG,
how is the differenence in speed of the A2???-Versions compared to
A97.
thanks for helping
Reiner



.

  #5  
Old February 4th, 2010, 12:12 AM posted to microsoft.public.access.forms
David W. Fenton
external usenet poster
 
Posts: 3,373
Default Speed of different Access-Versions

harmi wrote in

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


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.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
  #6  
Old February 4th, 2010, 02:04 PM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Speed of different Access-Versions

"harmi" wrote in message
...
On 3 Feb., 13:49, "Arvin Meyer [MVP]" wrote:
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

"harmi" wrote in message

...



HI NG,
how is the differenence in speed of the A2???-Versions compared to
A97.
thanks for helping
Reiner- Zitierten Text ausblenden -


- Zitierten Text anzeigen -


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


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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


  #7  
Old February 4th, 2010, 02:11 PM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Speed of different Access-Versions


"Dorian" wrote in message
...
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.


All of that is true.

In my opinion, if you are overly worried about speed, Access is the wrong
database for you.


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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:53 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.