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 <wanxing...@163.com> wrote:
> Hi , Yakov Zhdanov
> Actually I did not run H2 console, I run like this :
> cache.query(new SqlFieldsQuery("explain select id from assignInfo
> "));
>
> I change to like this:
> new SqlFieldsQuery("select * from Person p join table(id bigint = ?) i on
> p.id = i.id").setArgs(new Object[]{ new Integer[] {2, 3, 4} }))
>
> but it also need take 82 seconds.That did not change anything.
>
> Any other suggestion?
> Thanks a lot.
> Lucky
>
>
>
>
> At 2017-09-15 22:17:30, "Yakov Zhdanov" <yzhda...@gridgain.com> wrote:
>
> Please run explain from Ignite, not from H2 console -
> https://apacheignite.readme.io/docs/sql-performance-and-
> debugging#using-explain-statement
>
> Here you can find info on proper IN usage in Ignite -
> https://apacheignite.readme.io/docs/sql-performance-and-
> debugging#sql-performance-and-usability-considerations
>
> Thanks!
> --
> Yakov Zhdanov, Director R&D
> *GridGain Systems*
> www.gridgain.com
>
> 2017-09-15 4:50 GMT+03:00 Lucky <wanxing...@163.com>:
>
>> Hi
>> I have a table with 25,000,000 records.
>> The sql like this:
>> select fdatabasedid from databasedassign where fassingcuid
>> in(3589 ids) group by fdatabasedid have count(fassingcuid)>=3589
>> It return 1500 records.
>> But It took 82 seconds!!!
>>
>>
>> I see the explain like this:
>>
>>
>> Any suggestions?
>> Thanks.
>> Lucky
>>
>>
>>
>>
>
>
>
>
>
