>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
A view will definitely help. I currently use one as soon as the number of records > 20,000, but perhaps I should use it for even smaller tables. I don't currently, because of the additional work.
The view should be optimized, like any query. Note that sometimes, Full Rushmore Optimization is slower than Partial Rushmore Optimization. See my recent entry in FAQ for details.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)