Ayub,
On 6/15/21 18:43, Ayub Khan wrote:
Chris,
below is the method responsible for returning the data to the service api,
and its returned from service to the Rest controller
public MenuList getMenuMobileListNormalizedCombo(long a, long b, boolean c,
long d) throws Exception {
Connection con
Chris,
below is the method responsible for returning the data to the service api,
and its returned from service to the Rest controller
public MenuList getMenuMobileListNormalizedCombo(long a, long b, boolean c,
long d) throws Exception {
Connection con = null;
CallableStatement callableStatement
Ayub,
On 6/15/21 17:27, Ayub Khan wrote:
Chris,
I am getting the connection from the connection pool, defined using
HikariCP.
What I have noticed is, as soon as database results are fetched I am
printing it in the log, and I see there is a delay between when the results
are printed in the log
Chris,
I am getting the connection from the connection pool, defined using
HikariCP.
What I have noticed is, as soon as database results are fetched I am
printing it in the log, and I see there is a delay between when the results
are printed in the log to that of the response received by the
Ayub,
On 6/15/21 11:33, Ayub Khan wrote:
Would it be a cursor issue, as there seems to be how cursors are handled in
postgres and Oracle database. Below are the steps we take from jdbc side
1. open connection
2. set auto commit to false
3. create callable statement
4. execute
Chris,
Would it be a cursor issue, as there seems to be how cursors are handled in
postgres and Oracle database. Below are the steps we take from jdbc side
1. open connection
2. set auto commit to false
3. create callable statement
4. execute the call
5. get the results
6.
Ayub,
On 6/14/21 17:10, Ayub Khan wrote:
On Thu, 10 Jun 2021, 08:10 Ayub Khan, wrote:
Seeing client write waits on postgresql as attached in the image. Is there
any bottle neck which is causing the client write waits on postgresql ?
Below is the test setup
Jmeter-->(load balanced tomcat on
Chris,
In jprofiler I see that the threads are waiting on reading the response
from database side
On Thu, 10 Jun 2021, 08:10 Ayub Khan, wrote:
> Seeing client write waits on postgresql as attached in the image. Is there
> any bottle neck which is causing the client write waits on postgresql ?
Ayub,
On 6/11/21 13:52, Ayub Khan wrote:
jProfiler shows the threads are stuck with high cpu usage on. I am using
HikariCp connection pool management 3.1.0
org.postgresql.jdbc.PgPreparedStatement.execute
I am using 42.2.21 version of jdbc driver
Below is the Java code
Connection con = null;
jProfiler shows the threads are stuck with high cpu usage on. I am using
HikariCp connection pool management 3.1.0
org.postgresql.jdbc.PgPreparedStatement.execute
I am using 42.2.21 version of jdbc driver
Below is the Java code
Connection con = null;
CallableStatement callableStatement = null;
Ayub,
On 6/10/21 01:10, Ayub Khan wrote:
Seeing client write waits on postgresql as attached in the image.
Image attachments are removed from this list. Please use text to
describe what's happening.
Is there any bottle neck which is causing the client write waits on
postgresql?
Sounds
Seeing client write waits on postgresql as attached in the image. Is there
any bottle neck which is causing the client write waits on postgresql ?
Below is the test setup
Jmeter-->(load balanced tomcat on ec2 instances)>rds read replicas
All these are running on different ec2 instances in
12 matches
Mail list logo
