https://community.qlik.com/t5/Connectivity-Data-Prep/Data-Retrieval-inconsistent-in-Muti-node-environment/m-p/1688397#M5054 <P>Hello Experts,</P><P>We have a production environment with 3 Machines (1 central , a RIM and a Fail over RIM). We are having inconsistent performance in data retrieval . Our DB is oracle and we are using Oracle driver.</P><P>We are able to pull&nbsp; 1 million record in 30 secs and the same Query&nbsp; when re run it takes 5 mins at times and this behavior seems to be reappearing again and again.</P><P>We checked in DB/Network, it seems to be normal.&nbsp; My question here is&nbsp;</P><P>Why the performance in QSense is bad at some times? Is it because of multi node switching?</P><P>How can I find the logs to drill down the issues?</P><P>I am not an expert in Qlik Servers so please guide me to resolve this issues and let me know if you need more details.</P> Tue, 28 Dec 2021 20:37:12 GMT Veppvepp 2021-12-28T20:37:12Z https://community.qlik.com/t5/Connectivity-Data-Prep/Data-Retrieval-inconsistent-in-Muti-node-environment/m-p/1688397#M5054 <P>Hello Experts,</P><P>We have a production environment with 3 Machines (1 central , a RIM and a Fail over RIM). We are having inconsistent performance in data retrieval . Our DB is oracle and we are using Oracle driver.</P><P>We are able to pull&nbsp; 1 million record in 30 secs and the same Query&nbsp; when re run it takes 5 mins at times and this behavior seems to be reappearing again and again.</P><P>We checked in DB/Network, it seems to be normal.&nbsp; My question here is&nbsp;</P><P>Why the performance in QSense is bad at some times? Is it because of multi node switching?</P><P>How can I find the logs to drill down the issues?</P><P>I am not an expert in Qlik Servers so please guide me to resolve this issues and let me know if you need more details.</P> Tue, 28 Dec 2021 20:37:12 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Data-Retrieval-inconsistent-in-Muti-node-environment/m-p/1688397#M5054 Veppvepp 2021-12-28T20:37:12Z