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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|