Performance gain with Access running on 64 bit processor

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I am running 32 bit Access 2007 on a Dual Core laptop with 4 gig of ram. I
realize there are many variables to performance, but will I see a big
performance boost on Office 2007 Access (64 bit) w a 64 bit Dual Core with 6
~ 8 gig of ram.

Many of the apps we run have access files at 1.5 gig in size, again I know
are lots of variables, but does a 64 bit system really raise the performance
bar?

Thanks
 
Dave said:
I am running 32 bit Access 2007 on a Dual Core laptop with 4 gig of ram.
I
realize there are many variables to performance, but will I see a big
performance boost on Office 2007 Access (64 bit) w a 64 bit Dual Core with
6
~ 8 gig of ram.

Many of the apps we run have access files at 1.5 gig in size, again I
know
are lots of variables, but does a 64 bit system really raise the
performance
bar?

Thanks
Click to expand...

64 bit Access 2007? AFAIK, there is no such product. At least my MSDN
subscription does not list any version of Office 2007 as 64 vs. 32 bit.
If you're thinking of Office 2010, then, yes, it makes sense to get the 64
bit version of Office if you have 64 bit hardware/OS.
Even with Office 2007, my experience with 64 bit Win 7 (now installed on 3
desktops and one laptop in my home) is that everything just seems to work
better. IMHO, 64 bit has arrived. (I wonder when we'll see the first 128 bit
Windows :-)
 
hi Dave,
Many of the apps we run have access files at 1.5 gig in size, again I know
are lots of variables, but does a 64 bit system really raise the performance
bar?
Click to expand...
As Access is a 32-bit application, basically speaking: nope.


mfG
--> stefan <--
 
hi Dave,


As Access is a 32-bit application, basically speaking: nope.

mfG
--> stefan <--
Click to expand...

Thanks, for whatever reason I thought Office 2007 was 64 bit.

So this raises the question, anyone testing 2010 which I undertsnad is
64 bit. Does it raise the bar with Access performance

Thanks
 
Actually, you could increase your processing by 100 times, and you likely
will not see any notable change in performance.

Why?

Well, ms-access is not processor bound. In other words, your time that you
waiting for things is not based on processing (or lack of processing).
Ms-access is input/output bound. All your time spent is waiting for the disk
drive or network.

So, throwing more processing at ms-access likely will not have help it run
faster, and that likey been the case for about 5+ years or so.

in other words, all of the delays you experience are due to the speed at
which data can be pulled off the disk drive, or off of the network.

Simply speeding up processing will not change the speed of your disk drive
or your network.

So, the answer is even having a machine with 2 or 40 times the processing
you have now will not change the speed of ms-access in a noticale way for
pulling data. Access is not processing bound on a modern computer and has
not been so for a good number of years now..
 
PvdG42 said:
(I wonder when we'll see the first 128 bit Windows :-)
Click to expand...

Supposedly an MS researcher briefly posted his bio on LinkedIn
indicating that he was working on a 128 bit version of Windows.

I don't quite understand why as 64 bit is a large address space.

Tony

--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
Albert D. Kallal said:
Well, ms-access is not processor bound.
Click to expand...

Unless you're in an infinite loop. Of course I'm such a good coder
I've never had one. <giggle> <snort> <guffaw>

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
?So a 64 bit machine will complete an infinite loop more quickly than a 32
bit machine?

Skippy!
 
Maybe you should start a thread on the most efficient way to code an
infinite loop, Tony. <GRIN>

Larry
 
Maybe you should start a thread on the most efficient way to code
an infinite loop, Tony. <GRIN>
Click to expand...

Would that be defined as fewest lines of code or fastest execution
speed of each loop?
 
Larry Linson said:
Maybe you should start a thread on the most efficient way to code an
infinite loop, Tony. <GRIN>
Click to expand...

I wouldn't know. I"ve never done it.

Tony (year, right!)
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
David W. Fenton said:
Would that be defined as fewest lines of code or fastest execution
speed of each loop?
Click to expand...

Good question, David, and a good start on the thread.

Larry
 
Back
Top