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!

Register Log in
  • Congratulations Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VFP 6 Speed Issues on Network

Status
Not open for further replies.
Auguy

Auguy

Programmer
May 1, 2004
1,206
US
I have a VFP6 app running on a brand new server. The app is running really slow. A simple click on a 'Next Rrcord' button takes 15-20 seconds to refresh the form. On the old server it seemed that whenever the 3rd or 4th user signed on to the system, the whole system slowed down. I had attributed this to the old server, but the new one didn't seem to help, in fact it is worse, everyone is now running slow. Many of the forms open 20-25 tables, some have table buffering and some have record buffering, and some of the tables have a couple of hundred thousand records. I've had other apps running at other locations with many more users and records with no problem. Can someone give me a generic list of where I should be looking (Reinstall fox runtimes, Anti-Virus, etc.) Is there a setting on the local computers or the server about the number of file or record locks, or number of files open. Just thinking out load here and searching for anything that might help? Would porting it to VFP 9 help?

Auguy
 
Sort by date Sort by votes
No new ideas here. They are now running the app through Terminal Services which makes it fast, but causes other problems like no local drive access, etc. I have not had a chance to really investigate the issue at their site. Now that things have settled down after the new server installation, maybe I can do some more testing with the AV, etc. Good Luck, hope we find an answer!

Auguy
Sylvania, Ohio
 
Upvote 0 Downvote
but causes other problems like no local drive access, etc.
Click to expand...

Send the local drives over via Local resources... We do, printers as well, with an 85+GB pure VFP database app with 200+ tables each containing about 25 Million records and 100+ users in TS running on a Windows 2003 server. It runs in nano seconds.
I would definitely check out Dan's suggestion regarding the NIC cards. Also I would run the complete app in every scenario in Coverage profiler to check where it’s slow or for redundant calls/loops...

Good luck.
 
Upvote 0 Downvote
To AnyGuy. Are you using Citrix? Are all the patches implemented? On our system (2003 SBS) we've had to use Appsence to downgrade the CPU usage, for a host of apps, 16bit and 32bit.
 
Upvote 0 Downvote
Nope, No Citrix here!

Auguy
Sylvania, Ohio
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

A_Radiolog_inFoxPro
  • Locked
  • Solved
GETWORDCOUNT () IN VFP 6.0 ?
Replies
11
Views
795
StefanFoerner
StefanFoerner
GriffMG
  • Locked
  • Question
Not Strictly VFP - Cracking Password on Excel Spreadsheet
Replies
6
Views
334
Chris Miller
Chris Miller
infinetecode
  • Locked
  • Question
VFP Report : Dynamics
Replies
4
Views
389
Chris Miller
Chris Miller
RTD78
  • Locked
  • Question
VFP Form Refresh
Replies
2
Views
365
RTD78
RTD78
WedHouse
  • Locked
  • Question
concate on field vfp
Replies
1
Views
191
TamarGranor
TamarGranor

Part and Inventory Search

Sponsor

Back
Top