On Wed, 06 Apr 2011 16:14 +0000, "Dave Crozier"

<DCrozier@flexipol.co.uk> 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

_______________________________________________

Post Messages to: ProFox@leafe.com

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/1302163059.25473.1438416621@webmail.messagingengine.com

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