Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can i improve the Speed of the system
Message
 
 
To
23/04/1998 23:13:15
Jacky Yeung
Esprit Distribution
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00094568
Message ID:
00094580
Views:
23
>Backend Database?
>What does that mean?
>Is that SQL Server?
>I've only put the DBF Files at the network drive.
>
>Thanks

Back-End Database refers to Client/Server database that is being in used. Anyway, its now clear to me that you are not using C/S technology.
Slowing down of application has may factors involved. It is a question of how you designed your system. Here are some IMHO tips:

1. Optimize your syntax and index using Rushmore Technology of VFP (reference : Using Visual Foxpro 5 pg871, pg173)
2. If you are using Windows NT as Network OS then double check the settings (do not activate Screen Saver not compatible to NT OS, etc).
3. Do not use SET FILTER Command in exchange for Relation object on Data Environment (especially Master/Detail modules).
4. We rarely use FOR clause on SCAN, COUNT, SUM, CALCULATE etc. We use WHILE clause coupled with SEEK syntax (seeking the first record before SCAN etc.).

Above are just partial things to consider in developing Enteprise applications.

Hope it helps.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net

CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform