Hello!
Have you tried setting lazy=true for this query? Ignite has couple of ways
to do SQL, but each of those allows you to set lazy=true.
If this does not help, please try to add explicit SQL index on the field
that you're doing ORDER BY on.
Regards,
--
Ilya Kasnacheev
пт, 14 сент. 2018 г.
I am running on Kubertes three nodes. 32 caches are replicated across these 3
nodes.
Currently each node is Limited to 10 cpus and 30 Gigabits of memory. Caches are
persisted. Max heap memory is set to 18g.
Before running the query, with all nodes up and connect, I ran top and I see
that Ignit