Re: 2000 or 2003 app slow in Access 2007 (Vista)


"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> schreef in bericht news:4792bf15$0$17205$5a62ac22@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Each version of Access is slower than the one before on the same hardware.
Like the cynical Wirth's law:
Software gets slower faster than hardware gets faster.
(Source: http://en.wikipedia.org/wiki/Wirth%27s_law )
So, yes, A2007 is slower than previous versions.

Similarly, Vista is much slower that WinXP for some operations (particularly
deleting large files.) And the drivers are much less developed. When Vista
was first released, A2007 was so slow in design view, that there was almost
1 second delay in tabbing from one property to the next, and I constantly
found myself typing into the wrong property. This was largely solved when
nVidia released new drivers.

Office 2007 SP1 also addressed some performance issues. IMHO, A2007 without
SP1 is unusable - not from a performance perspective, but just unreliable.
None of my non-trivial apps would work reliably for all cases until SP1 was
released, so I would certainly not recommend it for any purpose beyond
experiementation (which was the OP's goal.) Some issues were not solved in
SP1 (e.g. assigning a specific printer to a report), but it's now quite
usable (though not hugely faster than the original release.) A major fix was
the delay when starting A2007 after using a previous version (down from 3.5
minutes to 18 seconds on my machine.)

There are other issues running Access (any version) under Vista, like
RunAsAdministrator, avoiding the virutalized folders, avoiding off-line
folders, and poor performance of intensive queries:
http://allenbrowne.com/VistaCPULoad.html

The OP was running on a laptop. As Linq Adams says, many laptops have
limited grunt, even more limited RAM, and poor graphics processing (stealing
even more system RAM.)

Suggestions:

1. Turn Aero off. You can live without the pretty translucent windows if the
laptop is more responsive.

2. Remove the "free" software that came installed on your computer.
Particuarly, the security stuff from Norton and others mean that the files
are being dragged through mud off your slow-spinning notebook drive.

3. If you have less than 2MB of RAM, consider adding more.
If you cannot do that, reduce the number of programs open at once.

You have probably already read Tony's suggestions for Access performance:
http://www.granite.ab.ca/access/performancefaq.htm

Thanks for the suggestions Allen. (also thanks to others who replied)
1 I turned Aero off, makes no noticeable difference (still have it off, because I heard/read it 'eates' resources)
2 I did remove all the Norton Security Software immediately. (I am using Avast at home)
3 I do have 2 Gigs of Ram on my laptop (Acer Extensa 5210)
I also did read Tony's suggestions. (Not for the first time...)

I am very careful in setting up this system.
I know it is not the best/fastest laptop one can buy, but 'heavy' software like Adobe Lightroom runs allright.
The sample Northwind 2007 database also runs fine ...

I am still thinking that opening or closing an *unbound* form would *not* have to take seconds.
==> New test:
A new database with *only* these three forms (and some basic modules) runs snappy.
When I simply import more objects (like 50 query's) from the original db the very same forms become 'muddy' (slow).
Corruption ?? I can't find anything.

What is happening ??
Is Access (or is it Vista ??) indexing the whole lot ??
I turn my anti-virus (Avast) software off ==> no difference.

Arno R
.

Relevant Pages

  • Re: OT: Vista or XP
    ... I didn't see anyone mention the most important thing with Vista and that is ... I dont know how much RAM does that laptop have but do NOT install Vista on ... Vista's memory useage seems higher than it really is, ...
    (alt.games.warcraft)
  • Re: very slow performance
    ... You are comparing two computers and say one is slower than the other. ... you did NOT say what CPU's are in each computer nor what speed RAM is installed in each computer. ... My teenager's laptop, a Toshiba Satellite series with Vista Home, big HD, 2 Gig RAM, usual stuff, runs extremely slowly. ...
    (microsoft.public.windows.vista.performance_maintenance)
  • Re: Microsofts "New Coke"
    ... The complaints I find funniest are those from the know-nothings who bitch that "VISTA is slower than XP." ... I neglected to check what her processor type, speed or RAM capacity is, so it may not be a fair comparison. ... Shovel the data out of one box, look at it, stir it up, shovel it into another box. ...
    (rec.boats)
  • Re: Help ...Which laptop model to buy????
    ... One thing to be aware of when buying low cost laptops these days, is how the memory is configured, especially if it comes with Vista. ... These days with Vista, I've found that while it will run acceptably with 1gig of ram, Vista really wakes up with 2gig of ram. ... If the laptop you buy has 1gig of ram, check to see if they use a single 1gig stick of ram, or I'll bet they use two sticks of 512meg ram. ... And for a $499 laptop, this has quite a few surprising extras, DVD burner, Firewire, PC card slot and built-in card reader). ...
    (alt.sys.pc-clone.dell)
  • Re: Vista & Ram??
    ... bit slower then XP Pro, noticeably slower(boot up/shut down is much ... My thinking is ram is the culprit, I have a E-520 with a 3.06Ghz ... the sweet spot for XP 2Gb is the sweet spot for Vista.. ...
    (alt.sys.pc-clone.dell)