>I have developed a program using VFP 6.0 that will do reservations for our golf and tennis facilities. When I did this I was told that all of our 43 facilities would have T1 lines. What I wasn't told was that they would only be fractional T1 lines and they have only 64k of bandwidth at each facility.
>
>I have been able to write all of the screens to work efficiently except the one that adds records to the main scheduling table. This table has ten indexes in a .CDX file and adding a new record takes several seconds just to execute the APPEND BLANK statement or to execute a SQL INSERT statement. I have the program running on each user's PC and it just goes through the network to access the data. I have also tried using stored procedures to add the new records but that does not work any faster.
>
>Do you have any suggestions for what I can do to speed up the adding of these records.
>
>Thanks for any help you can provide.
>
>Mike Tennor

There is not a great deal you can do, to achieve a 'considerable' performance boost. Removing any CDX Tags that are not absolutely critical might give you a small benefit. Switch entirely to parameterized views (which would have to be opened with NODATA), etc.

You really have only two options to achieve the kind of improvement that you are looking for:

1. Switch to a true Client / Server arrangement (perhaps using MSDE if your connections can get by with being created and dropped for each transaction). Depending upon how you have architected your App, this could be very painful.

2. Try Terminal Services. This is probably the least painful approach. Win XP has the client component built in. It’s a free download for Win 2K. I wouldn't consider this approach for 95, 98, ME, etc.