>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

---

If it is a form with a pageframe you can consider to place the controls on the pages into container controls. Then save the container controls with the other objects in it to a class.
When the user loads the form not all the controlls are loaded.
When te user clicks on a TAB then you add the container using addobject()

Maybe this helps,