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/
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:
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.
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