Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Minimizing Network traffic - ideas wanted!
Message
De
04/11/2009 17:55:45
Neil Mc Donald
Cencom Systems P/L
The Sun, Australie
 
 
À
03/11/2009 23:20:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01433035
Message ID:
01433263
Vues:
84
Hi,
Try running the app using Terminal Services and see what happens, it is the quickest way to overcome poorly setup/configured/stuffed up networks.

>Hey FoxFolx!
>
>I've got a question on the situation with network traffic when it comes to VFP tables. We have set up calls to a large table on a network server to utilize minimalize database calls (i.e. UPDATE pttran SET status = 1 WHERE id = 12345). However at one company in particular that really bangs on the system with many workstations, some system utilities that take 2-3 minutes on a local system are taking 30 minutes to run.
>
>My question is this: if the example above were in pure SPT to a SQL table, it would truly be minimal, but is it actually passing lots of data back and forth in VFP? I was re-reading Chuck Urwiler's VFP C/S book and he spoke of how sometimes using a remote connection in such a situation might be better. Do you folks agree?
>
>How about a stored procedure inside the VFP database? Would passing a call to that keep everything on the server?
>
>I'm baffled about how to rectify this situation. I'd love to hear those who know more than me on this subject.
>
>Anyone? Thanks a LOT in advance!
>
>-- John Kiernan
Regards N Mc Donald
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform