What method are you employing to read/write to/from the vfp tables?


>Hello,
>
>We installed a ticket software on a remote location that has a 10 Mbps link to the main server. The software uses VFP tables and does some usual queries and record locks, but nothing to extravagant.
>
>However, we see that the network utilization often spikes up to 4 Mbps when doing a ticket sale for example.
>
>That causes the system to slow down dramatically when 2 or more computers are processing simultaneously.
>
>Before I am going to try to change the software to use less bandwidth, does a usage of 4Mbps sound particularly huge for VFP tables, or is this in the "normal" range of bandwidth usage? Because if I cannot hope to decrease the bandwidth to let's say only 1 Mbps maximum, I would have to consider rewriting the software to a client / server application.
>
>So I would like to know if somebody can give me some figures about what to expect. I am of course aware of the fact that it largely depends on the queries and size of data that gets transferred, but nevertheleless I do need a kind of a starting point to come to a final conclusion.