Re:Re: Re: Fetched result use too much time

2017-09-16 Thread Lucky
I do not understand your points exactlly. but I have post the screenshot here. It is the output of the "explain" query. Can you see that? At 2017-09-16 15:28:23, "Dmitriy Setrakyan" wrote: Lucky, We would like to see the output of the "EXPLAIN" command for the query that takes a long t

Re: Re: Fetched result use too much time

2017-09-16 Thread Dmitriy Setrakyan
Lucky, We would like to see the output of the "EXPLAIN" command for the query that takes a long time, so we could make suggestions. Can you post it here? D. On Fri, Sep 15, 2017 at 11:50 PM, Lucky wrote: > Hi , Yakov Zhdanov > Actually I did not run H2 console, I run like this : >

work around for problem where ignite query does not include objects added into Cache from within a transaction

2017-09-16 Thread kotamrajuyashasvi
Hi When a transaction is started and some rows are updated/inserted/deleted in a cache which is in transactional mode, And after that when I perform a select query, its not reflecting the results from of update/insert/delete done before with in the transaction. I found out that ignite sql does no