Performance gain with Access running on 64 bit processor

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
 
P

PvdG42

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

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 :)
 
S

Stefan Hoffmann

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?
As Access is a 32-bit application, basically speaking: nope.


mfG
--> stefan <--
 
D

Dave K

hi Dave,


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

mfG
--> stefan <--

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
 
A

Albert D. Kallal

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

Tony Toews [MVP]

PvdG42 said:
(I wonder when we'll see the first 128 bit Windows :)

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/
 
T

Tony Toews [MVP]

Albert D. Kallal said:
Well, ms-access is not processor bound.

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/
 
J

Jeff Boyce

?So a 64 bit machine will complete an infinite loop more quickly than a 32
bit machine?

Skippy!
 
T

Tony Toews [MVP]

L

Larry Linson

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

Larry
 
D

David W. Fenton

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

Would that be defined as fewest lines of code or fastest execution
speed of each loop?
 
T

Tony Toews [MVP]

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

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/
 
L

Larry Linson

David W. Fenton said:
Would that be defined as fewest lines of code or fastest execution
speed of each loop?

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

Larry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top