I’m working on a program that needs to be accessed from more than one location, but only one user at a time will be allowed access the program. For that reason I need to use the network which is dragging down the performance of my program. I’m doing my best to avoid using the network like crunching the data on the local drive first but eventually need to store the data on the network. Are there any techniques I may use to help me speed things up? Also if it’s worth mentioning, monthly I’m adding roughly 250,000 records.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Performance techniques?
- Thread starter RussA
- Start date
- Thread starter
- #2
May I assume you are using Service Pack 5 with VFP 6.0?
The best performance enhancement is to speed up your network - 1gb or fiber. There is little you can do in VFP if the Nics, cables, hubs, routers, switches, etc. are your bottleneck.
Rick
The best performance enhancement is to speed up your network - 1gb or fiber. There is little you can do in VFP if the Nics, cables, hubs, routers, switches, etc. are your bottleneck.
Rick
Mike Lewis
Programmer
RussA,
Make sure all your queries are Rushmore-optimised. With luck, that could reduce the network traffic (but only in favourable circumstances).
For a more extreme solution, consider switching to a client-server back-end, like SQL Server. It will be expensive and time-consuming, and not something to be undertaken lightly, but if network degradation is really killing your app, it will solve the problem.
Mike
Mike Lewis
Edinburgh, Scotland
My Visual Foxpro web site: My Crystal Reports web site:
Make sure all your queries are Rushmore-optimised. With luck, that could reduce the network traffic (but only in favourable circumstances).
For a more extreme solution, consider switching to a client-server back-end, like SQL Server. It will be expensive and time-consuming, and not something to be undertaken lightly, but if network degradation is really killing your app, it will solve the problem.
Mike
Mike Lewis
Edinburgh, Scotland
My Visual Foxpro web site: My Crystal Reports web site:
- Status
Similar threads
- Locked
- Question