Hello guys
I am reviewing a custom forms module for booking sales orders and could see that the earlier developer has a pretty complex view for price lists. I have broke down the SQL and realized the view could be totally avoided and instead a much lighter SQL statement could be used for fetching the end results (single column value)
This application has approximately 80 users online around the clock & please help to make a decision based on the below queries
- Over a multi-tier application structure (Oracle E-Business Suite R12), where exactly the view is loaded? Client computer's memory or the in the server's memory?
- What happens when the users are continuously requesting data from this particular view. Each line item MUST fetch a column value from this particular view and satisfy business conditions. Does this mean the view is refreshed each time when the information is sought?
- Is this view is shared among others users as each and every user will be referring to the same view as they all are using the same form? On the other hand if the view is populated during each call, there should be a tremendous resource hogging. Under this circumstance, using simple SQL statement could boost the performance and reduce the resource consumptions?
Please post your valued comments and materials which could help me to understand the situation better,
regards,
rajesh