Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Application speed/response time issue.
Message
From
17/10/2006 19:03:50
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
17/10/2006 16:57:10
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01162674
Message ID:
01162757
Views:
18
Hi Amanda

>The database only is on the 2003 server. The exes are on each of the workstations. The workstations are all Windows XP Pro SP2.

The .DBC is shared. This can be a bad thing with views.

http://fox.wikis.com/wc.dll?Wiki~CreatingDBCforViews

Additionally, the DBC itself has code in the form of stored procedures. Having it also on the local machine will reduce network traffic and improve performance. This can be done with a launcher. When the user tries to launch your app, a smaller app is triggered instead. This app determines if the files on the local one are older than the ones on the server and copies the newer ones to the local. Once copied it runs the local.

HTH
Previous
Reply
Map
View

Click here to load this message in the networking platform