Re:Re: Fetched result use too much time

[Lucky]

Hi , Yakov Zhdanov

    Actually I did not run H2 console, I run  like this :
        cache.query(newSqlFieldsQuery("explain select id from assignInfo "));


    I change to like this:
newSqlFieldsQuery("select * from Person p join table(id bigint = ?) i on p.id = 
i.id").setArgs(newObject[]{newInteger[]{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