Slow database performance

[proton]

I am in charge of a third party VFP 5.0 database. At times the response is excruciatingly slow. This involves both screen redraws and data retrieval. We have a Compaq server running Win NT 4.0, 10baseT ethernet, Cabletron switches, Pentium Win95 desktop clients with various NIC cards. The developers blame the network and the Network Admin blames VFP. What monitoring tools or methods are available to begin to get a picture or what's causing the bottleneck.

 

[NumberFive]

Has the database been normalized? if the database is poorly structured, It'll be slow as heck.

 

[MasterRacker]

Is there any pattern to when it is slow versus when it runs acceptably? <p> Jeff<br><a href=mailto: masterracker@hotmail.com> masterracker@hotmail.com</a><br><a href= > </a><br>

 

[DougP]

Are you running Novell and NT on the same Network?<br>
If so and the Fox pro database is on NT it will be slow as with Access '97 same problem.<br>
Fox Pro is slow on a standalone PC anyway.<br>
Upgrading to 10/100 cards will improve performance 10 times<br>
and you need to have 10/100 hubs but in the year 2000 they are cheap.<br>
Also we did a test on a Pentium I 166 versus a Pentium II 266<br>
It made a difference that was astounding.<br>
the Access database using ODBC was slooow

http://www then

switching to PII 266 was very fast using 10/100 all around.<br>
PC's are a lot cheaper today than unproductive employee's.<br>