ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nikolai Tikhonov <ntikho...@apache.org>
Subject Re: Query execution is too long warning while running Yardstick-ignite
Date Wed, 22 Mar 2017 15:39:07 GMT
Hi,

Which dataset did you use for this benchmark? Also could you share your
cache configuration?

On Wed, Mar 22, 2017 at 7:30 AM, ronyjohn <ronyjhn@gmail.com> wrote:

> 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