Be sure to optimize your SQL queries by analysing simulations with sys(3054). You may need to re-arrange the SQL statement and you may also need additional indices. If you are using views in your form, make sure that the view definision is also optimized for faster instanciation.



>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