ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ronyjohn <rony...@gmail.com>
Subject Query execution is too long warning while running Yardstick-ignite
Date Wed, 22 Mar 2017 04:30:32 GMT
Hi All,
  I am getting query too slow warning message while running Yardstick-ignite
benchmark. Not sure why indexed query is slow here. 
machine configurations is 4 core CPU with 16 GB ram. 
Topology snapshot [ver=1, servers=1, clients=0, CPUs=4, heap=3.5GB]
 


WARNING: Query execution is too long [time=4659 ms, sql='SELECT
"query".PERSON._KEY __C0,
"query".PERSON._VAL __C1
FROM "query".PERSON
WHERE (SALARY >= ?1) AND (SALARY <= ?2)', plan=
SELECT
    "query".PERSON._KEY AS __C0,
    "query".PERSON._VAL AS __C1
FROM "query".PERSON
    /* "query"."salary_idx": SALARY >= ?1
        AND SALARY <= ?2
     */
WHERE (SALARY >= ?1)
    AND (SALARY <= ?2)
, parameters=[1.343909556640499E8, 1.343919556640499E8]]


Any suggestions?






--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Query-execution-is-too-long-warning-while-running-Yardstick-ignite-tp11348.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Mime
View raw message