Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can i speed-up my application.
Message
From
11/08/2001 10:12:06
Charlie Schreiner
Myers and Stauffer Consulting
Topeka, Kansas, United States
 
 
To
11/08/2001 07:10:57
Minesh Bhatt
Ptc Software Ltd.
Mumbai, India
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00542631
Message ID:
00542656
Views:
18
Hi Minesh,
The way to make it faster is to take out the slow parts! (Jim Boooth quote) One way to determine the slow parts is to SET COVERAGE TO Cover.TXT and analyze the results. Find one or two things on which to concentrate your efforts.
I would guess at two places to start:
1. SQL statements that aren't taking advantage of good indices
2. Refreshes in the form that do too much.
Report your findings.

>Dear All,
>I have made a application For Invoicing. The Tables of this application consists of large number of records, upto 45000 records atleast 90 mb.I am executing SQL statements already to speedup my app but it still seems to be slow, since user have to wait for few sec, which he do not want to tolerate.
>This app runs on P3. It takes time even to load form since it has many control on it.
>Can View Help me inorder to get rid of this.
>ThankU in advance
Charlie
Previous
Reply
Map
View

Click here to load this message in the networking platform