Re: IGNITE performance very very very less !!!

2018-05-29 Thread the_palakkaran
Hi Andrew, I have found what is causing problem here and moved it into a more specific thread: http://apache-ignite-users.70518.x6.nabble.com/QueryCursor-getAll-performance-is-very-very-low-td21691.html -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: IGNITE performance very very very less !!!

2018-05-29 Thread the_palakkaran
Hi Andrew, I had analyzed this further and found out that actually ther cursor getAll is making it slow. I have pointed this out in the thread below: http://apache-ignite-users.70518.x6.nabble.com/QueryCursor-getAll-performance-is-very-very-low-td21691.html -- Sent from:

Re: IGNITE performance very very very less !!!

2018-05-29 Thread Andrey Mashenkov
Hi, Why you think the performance is slow? Ignite SQL has an H2 underneath and have some overhead as it is a distributed system at first. So, local query latency can be slightly higher. How do you measure query latency? You may need to warm grid up to all components involved in query initialize.

IGNITE performance very very very less !!!

2018-05-29 Thread the_palakkaran
Hi, I have 200 caches loaded into a single data region. Among that I have a customerCache which has 300K records. It has many indexed fields, including customer number. When I query using *SQLFieldsQuery *on this particular cache (where condition has just customer number = ?), it takes around