Slow query in JDBC

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Slow query in JDBC
From: Subramaniam C <subramaniam31784@xxxxxxxxx>
Date: Thu, 28 Sep 2017 13:49:30 +0530

Hi

When I try to execute the query from sql command line then that query is taking only around 1 sec. But when I execute the query using JDBC(Java) using preparedStatement then the same query is taking around 10 secs.

Can you please let us know the reason and how to fix this issue?

Thanks and Regards

Subramaniam

Follow-Ups:
- Re: Slow query in JDBC
  - From: Julien Rouhaud

Prev by Date: Re: query of partitioned object doesnt use index in qa
Next by Date: Re: Slow query in JDBC
Previous by thread: Parallel sequential scan not supported for stored procedure with RETURN QUERY EXECUTE ?
Next by thread: Re: Slow query in JDBC
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux