Re: [MS_AccessPros] performance access very slow in 64 bit

 

Valentino-

When you run a 32-bit application on 64-bit Windows, there's extra overhead having to "thunk" all the 32-bit address to actual 64-bit and back, but it shouldn't be that noticeable.  What are the other characteristics of the two machines?  How much memory on each?  How fast is the processor?  Access is particularly sensitive - especially when running complex queries - to the amount of memory available.  In earlier environments (Win 98), you could often double the speed of Access simply by adding more memory.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On May 31, 2014, at 8:28 AM, 'valentino avvisati' valentino.avvisati@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Good morning,

 

I have built an application in microsoft access 2007 that is doing some elaboration (repetitive query and successive elaboration on data extracted)

The database is divided I two file, (the second file just stock some tables  ad Is located in same directory of main file mainly because , during the elaboration,  the file increase very fast ii dimension)

The procedure run In around 30 minutes in windows xp 32 bit environment and also under windows 7 32 bit. This is ok for me.

the same file moved to windows 8.1  office 2013 (or also windows 7) but 64 bit machine , take so long time that I always stop before end (4-5 time more)

I'm not sure if the problem is really the 32 bit environment or due to the fact that I do not follow all the rules to be efficient, but it look like is appearing only when I move to 64 bit machine

Somebody knows why this occur and possible solution?

 

Thank you to all (really very useful group)

 

Valentino Avvisati

 

 

 

 

 

 

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___