Hi OpenTexters,
Our DB server has a performance issue in production environment. It retrieves contents by every select sql statement. I want to get the implementation of Java code to get some contents by caching solution in order to avoid overloading DB.
For example:
(1) Get all the content instances by
A. the CTD is: "CTD_A";
B. associated with the channel "channel_a".
(2) Get all the content instances by
A. its value of attribute "MASTER-GUID" is "****";
B. associated with the channel "channel_a".
Appreciate your help to give the Java code examples to get all the content instances by caching solution. How to achieve these 2 goals? Thanks for your response!