Hi Rohit ,
Please see if some obvious indexes are being missed.
if using postgresql , 'explain analyze' is your friend. If queries
are not optimal other optimizations are short-term relief.
regds
mallah.
On Wed, Jun 13, 2018 at 11:26 AM, Rohit Rai
wrote:
> Hi Rajesh,
>
> Thanks for your
Hi Rajesh,
Thanks for your reply. I tried count(*) beforehand it returned a time-out roll
back.
Rohit Rai
www.hotwaxsystems.com
On Mon, Jun 11, 2018 at 5:13 PM, Rajesh Mallah
wrote:
> Hi Rohit ,
>
> for huge-sized resultset you should ideally use paging.
>
> Also try to see how long does
Hi Rohit ,
for huge-sized resultset you should ideally use paging.
Also try to see how long does the query takes to execute.
you may use count(*) in place of the selected columns
to estimate it.
regds
mallah.
On Mon, Jun 11, 2018 at 4:39 PM, Rohit Rai
wrote:
> Hi folks,
>
> I encountered a