Alan,
MANY thanks for your time to send the info below!!!
One puzzler....why is the same routine slow when the code only has to
load from a 23,000 record DBF file that is local (in the same folder as
the EXE)?
I tried by commenting out all the code that fetched the data from the
server, created a simple "SKU.DBF" file with one field, SKU. Saved
SKU.DBF in the same folder as the EXE and loaded the data with:
----------------------------------
use sku in 0
select sku from sku into array laSKU order by sku
use in select('sku')
for nnum=1 to alen(laSKU)
thisform.ctGrid.addcomboitem(1, laSKU(nnum))
endf
-----------------------------------
The above is about 4 seconds faster, but still takes 75 to 76 seconds.
And, according to the profiler, the slowest step in the above is the
"addcomboitem" method.
I have contacted DBI (creator of the ctGrid) and they claim they can not
recreate the problem. I've tried creating a small, 1 form EXE file that
only does the ctGrid and load, and OF COURSE IT IS FAST. The exe is only
48kb.
I suspect it has something to do with my app being 6Mb and somehow that
is creating issues with VFP9's memory management.
Mike
> Mike
>
> I deal with a large VFP9 application that is installed on thousands of
> sites, and we are seeing occurrences of this also, to the extent where a
> customer will bring in a new Windows 7 machine and it will be extremely
> slow, with the other 5-year-old XP machines on the network being fast at
> the same operations.
>
> This application has EXE and supporting files locally on the clients,
> accessing data on a server share.
>
> My suspicion is that this is due to the different network stack in
> Windows 7, crappy Windows 7 drivers for network cards, differences in
> the way it negotiates with network hardware, or a combination of these.
>
> I don't have one of these problem sites near me to investigate at the
> minute unfortunately.
>
> If you have a Windows Server 2008 in the mix you definitely need to
> either set the server to use SMB1 over SMB2, or alternatively apply the
> SMB2 hotfix that MS released recently. This will stop index corruption
> issues at the very least.
>
> There is also talk that turning off Remote Differential Compression may
> help, see here:
>
> http://serverfault.com/questions/85965/slow-network-file-copy-on-windows-7
>
_______________________________________________
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.
