Alan, Nice find. I did the same with a few of our PC's and id does make a dramatic difference when opening tables for browsing in grids.
Thanks Dave C -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Alan Bourke Sent: 07 April 2011 08:58 To: [email protected] Subject: RE: Windows 7/Office 2010 rollout On Wed, 06 Apr 2011 16:14 +0000, "Dave Crozier" <[email protected]> wrote: > 3. Opening DBC's on network shares for some reason seems to take an > absolute age (VFP9) compared with XP. This, you will propbably find, is > down to the anti-virus, so you should exclude dbf, fpt, cdx, dbc, dct, > dcx file types from being scanned on opening. This will only help but not > completely cure the problem. Just on that one ... I work for a company that sells a large VFP9 application that is installed on thousands of customer sites. This application has EXE and support files on the client PCs and other metadata and actual data accessed over UNC shares. It basically uses hundreds of DBF files. Customers have recently started upgrading to Windows 7, 64-bit in most cases. Quite a few were complaining that the brand new Windows 7 machines were considerably slower than even really old XP boxes when using this app. Like taking two minutes to log in, in extreme cases. In almost every case we have found this to be down to network card drivers and settings. The one change that I have found makes a huge difference is what is called 'Interrupt Moderation' on Intel cards, and a similar name on Broadcom and Realtek. This will be 'on' by default, and is intended to reduce CPU load by batching network requests and then generating one interrupt to send them, rather than one interrupt per request. However with things like our application it has the opposite effect. Turning it 'off' is a night-and-day difference in speed. The other thing I would say is - ensure that the Windows 7 and Server 2008 if applicable are on the latest service pack, as this removes the problem where you have to turn off SMB2 to stop VFP index corruption. Oh, and make sure it's Office 32-bit, not Office 64-bit. -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
