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