We have an application in which performance is paramount. A set of containers, jsp pages, need to be developed with a good performance in terms of data retrieval. Which of the design patterns - M1 model or Struts -would be preferred ? Or is there any other suitable model? The database operations of the new pages are read-only i.e select queries only.
posted 11 years ago
M1, MVC struts etc are patterns for user interfaces - they have nothing to do with data retrieval.
Performance in read operations is a matter of - tuning queries - ensuring database query cache is optimally configured - employing an object cache in the application tier
The third will give the best results as it minimized network traffic, but it is the hardest to implement.