ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rajesh Mallah <mallah.raj...@gmail.com>
Subject Re: EntitySQLProcessor Transaction time-out
Date Mon, 11 Jun 2018 11:43:56 GMT
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 <rohit.rai@hotwaxsystems.com>
wrote:

> Hi folks,
>
> I encountered a transaction time-out while performing a MySQL query from
> EntitySQLProcessor perhaps due to the huge size of the result set.
>
>
> Is it possible to increase the time-out or is there any other way to deal
> with this? Please advice.
>
>
> Earlier, when I faced the same issue while performing a delete query I
> dealt with it by limiting the rows. But, this time I need to perform a
> select query.
>
>
> Rohit Rai
> www.hotwaxsystems.com
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message