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