Hoi Erwin,

Like the other have said there are various things to look at.

1. Anti virus software
2. Network architecture
3. Netword load.
4. Optimizing data retrieval.



1. Some ANTI virus software do cause slow access to shared files. E.G. with Norton antivirus, disable auto-protect

2. Just test your software on the slowest LAN available. I've got a 10base2 coax network to test my application on. If it runs o.k, there it should do anywhere.

3. Be aware that exclusive access is different from shared access. By that I don't mean opening the tables exclusively with USE .... EXCLUSIVE, but that a file is exclusively opened by one user and buffering data (both read and write). NT has an optimizing feature that opens tables exclusively for one user, but when a second user opens the table it reverts to shared use by forcing the fluch of the write and/or readbuffers. this mechanism is called exclusive op(protunistic)locking. So when testing you performance alway's do this in a multi user environment where more than one workstation has opened the tables and written contents to that table.

4. You can try to get you data another way. XBase commands like SEEK, SCAN WHILE, CALCULATE ... WHILE, etc might be far faster than SQL -Select. If using SQL - Select, you'll have to make sure that you have the proper indexes to let rushmore do its work efficiently (DON'T use low selective indexes like INDEX ON TAG DELETED())

Walter,


>Hi there,
>
>last week we installed our software on the client's side.
>Than we found that the network communication is very slow.
>
>Here is what we do;
>
>(At our side the time from question -> answer is about 1 - 2 seconds)
>
>- Let the user enter a clientname or clientnumber
>- Execute a query on a database that is on a server (so that every user has the same (up2date) tables)
>
>At the client's side the time from question -> answer is about 20 seconds!
>
>We do not use any Database manager like SQL-Server, just VFP tables and indexes.
>
>What can I do to improve the performance of this communication?
>
>Cheers,
>
>Erwin