Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Abysmal table open times on one workstation
Message
From
28/02/2001 03:45:39
 
 
To
28/02/2001 02:23:59
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00480266
Message ID:
00480433
Views:
13
>Hi Erik,
>
>I've had something simular on one of my new 700 mhz celeron machines. It has a motherboard with all except the networkcard on-board. When I setup the machine and tried to start my VFP applications it did seem to open tables about two or three times slower than on my good old P133 mhz.
>
>After monitoring the network I came to the conclusion it did not use the whole bandwidth of the the network when opening forms, so I concluded something was wrong with the network card or its configuration. After cheking all it settings I moved it to another PCI slot and this nicely solved the problem.
>

This probably moved it to a different IRQ - the IRQ is tied to the Slot. You probably could have gotten the same effect adjusting the PCI Steering registers in the BIOS.

>HTH,
>
>Walter,
>
>
>>One of my clients just bought a new workstation for one of their power users- Dell Dimension 8100 with a P4 1.3G, 256 MB RAM, Win2K Pro, VFP6 SP3.
>>
>>After getting all the OS set up, and the applications installed, we notice that our VFP apps run _very_ slowly on that machine only. Form load times are measured in minutes, when normally they open in 1-2 seconds.
>>
>>I opened VFP 6 and started testing the time that it takes to open files on the network, and found some very bizarre behavior. A 5K table in a dbc on the network drive takes 3-4 seconds to open, and a 60 MB free table opens instantly. Any table that is in a DBC takes a very long time to open, and all free tables open quickly.
>>
>>Additionally, It takes about 1 minute to MODI FORM a moderately complex form with subclassed controls that opens in 2-3 seconds from other workstations, but USEing the scx file from the problem workstation opens it instantly.
>>
>>The only rhyme or reason I can put to any of this is that it seems that opening a table (dbf or scx) that requires that VFP open one or more other tables upon using it causes the delay- using any 'free' table is quick.
>>
>>Anybody ever run into this?
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform