Go Back   Access World Forums > Apps and Windows > Hardware Questions and Answers

 
Reply
 
Thread Tools Rating: Thread Rating: 3 votes, 5.00 average. Display Modes
Old 09-30-2013, 02:12 AM   #1
phinix
Newly Registered User
 
Join Date: Jun 2010
Posts: 76
Thanks: 0
Thanked 0 Times in 0 Posts
phinix is on a distinguished road
Laptop or Ultrabook for MS Access work

Guys, I'm after a laptop for Access databases work.
Not 100% sure what specification would be best for it.
I believe Access doesn't use HT? Does it mean that having 4 cores won't make difference compared to i7 dual core with HT?

Would something like Dell XPS 13 MLK be ok for it?
It's a ultrabook with i7-3537U Processor (with Turbo Boost 2.0 up to 3.10 GHz).
It would have 8GB of RAM and 256GB SSD.

Right now I work on desktop i5 2400 3GHz CPU. Now I need to go mobile and need to get a laptop. Would this mobile i7 CPU make huge difference compared to this desktop version of i5? It is slower but would it make a difference for Access?
What system resources are most important for MS Access? I know already that SSD makes huge difference. 8GB is a must for me, noticed it many time working on few databases at the same time. What about CPU? New Haswell i7 4500U is almost same as ivy i7-3537U, so would I notice a difference using either of those i7 compared to my desktop i5?


Last edited by phinix; 09-30-2013 at 02:29 AM.
phinix is offline   Reply With Quote
Old 10-01-2013, 01:12 AM   #2
phinix
Newly Registered User
 
Join Date: Jun 2010
Posts: 76
Thanks: 0
Thanked 0 Times in 0 Posts
phinix is on a distinguished road
Re: Laptop or Ultrabook for MS Access work

What I want to know is CPU influence on Access processing.
Does Access use multiple cores? or Hyper threading?
Having same spec but different CPUs - one dual core, one quad - would I see a huge difference between those two? Would quad core be lot faster than dual core CPU?
phinix is offline   Reply With Quote
Old 10-02-2013, 12:20 AM   #3
phinix
Newly Registered User
 
Join Date: Jun 2010
Posts: 76
Thanks: 0
Thanked 0 Times in 0 Posts
phinix is on a distinguished road
Re: Laptop or Ultrabook for MS Access work

54 views and no reply?
Maybe it's in wrong section?

phinix is offline   Reply With Quote
Old 12-10-2014, 04:08 PM   #4
Timo van Esch
Newly Registered User
 
Join Date: Oct 2013
Posts: 18
Thanks: 4
Thanked 0 Times in 0 Posts
Timo van Esch is on a distinguished road
Re: Laptop or Ultrabook for MS Access work

Hi,

As far as I know, Access 2007, as a process, not only as a database, can only be started on 1 core. But I am not sure; it is why I stumbled upon your question. I am basically looking for a way to speed things up and let Access use multiple cores...
Timo van Esch is offline   Reply With Quote
Old 12-13-2014, 08:30 AM   #5
Minkey
Newly Registered User
 
Minkey's Avatar
 
Join Date: Jul 2004
Location: London, UK
Posts: 661
Thanks: 0
Thanked 8 Times in 8 Posts
Minkey will become famous soon enough
Re: Laptop or Ultrabook for MS Access work

As far as I know Access (all versions) run on 1 CPU core, hyper threading is the realm of the O/S essentially multi core CPU(s) allow you to run multiple applications at the same time hyper threading can increase the efficiency of an application within a core providing it is designed to work that way (with the O/S).

The key to running most applications faster, if the CPU can run the app without maxing out, is RAM and hard drive read/ write speed so a SSD drive is good choice. In theory anything can run faster if you throw more CPU, RAM and HD power at it so as I usually say get the fastest machine you can afford with the most bang for buck if that's what you need.
__________________
__________________________________________________
"People should not be afraid of their governments.
Their governments should be afraid of their people" V
.................................................. .....................

Schrodinger's cat walks into a bar........and doesn't
Minkey is offline   Reply With Quote
Old 12-13-2014, 09:39 AM   #6
namliam
The Mailman - AWF VIP
 
Join Date: Aug 2003
Location: Amsterdam/The Netherlands
Posts: 11,388
Thanks: 0
Thanked 799 Times in 786 Posts
namliam is a glorious beacon of light namliam is a glorious beacon of light namliam is a glorious beacon of light namliam is a glorious beacon of light namliam is a glorious beacon of light
Re: Laptop or Ultrabook for MS Access work

Disk I/O is definately one of the more limitting factors of any database now a days, access more so than i.e. Oracle or mySQL, since its I/O goes on the local machine or on the network.

5400 rpm laptop harddrives can cause some issues here and there when you have heavy I/O

__________________
ruoY yppah namliaM si syawla yppah ot pleh
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.



To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Remember to use the scales (Bottom left) or the thumb (bottom right)

Always looking for new challenges (Amsterdam Area)
namliam is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for a laptop speakers_86 The Watercooler 22 09-26-2011 07:49 PM
New Laptop from Work - Queries don't work???? sportsguy Queries 1 06-14-2009 04:55 AM
Easiest way to replicate PC Access database on laptop? mmp97 General 3 07-31-2008 04:15 AM
Copying an access file to a laptop JReichnan Modules & VBA 1 03-13-2006 04:55 PM
onKeyPress doesnt work on laptop bruced3846 Forms 0 06-27-2005 11:03 AM




All times are GMT -8. The time now is 06:29 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World