Hello bearrito,
What Execution plan in you query, indexes used?
https://apacheignite.readme.io/docs/sql-queries#using-explain
You query can split to 2 different query
SELECT internalMissionId FROM STATEFULROBOTTELEMETRY S2 WHERE
S2.internalRobotName = ? ORDER BY internalTimeStamp DESC LIMIT 1
and
SELECT S1.* FROM STATEFULROBOTTELEMETRY S1 where S1.internalRobotName = ?
and internalMissionId = ?
also can be help rewriting qury to
SELECT S1.* FROM STATEFULROBOTTELEMETRY S1
INNER JOIN (
SELECT INTERNALMISSIONID FROM STATEFULROBOTTELEMETRY S3
WHERE S3.INTERNALROBOTNAME = ? ORDER BY S3.INTERNALTIMESTAMP DESC
LIMIT 1)
S2 ON S2.INTERNALMISSIONID = S1.INTERNALMISSIONID
WHERE S1.INTERNALROBOTNAME = ?
--
View this message in context:
http://apache-ignite-users.70518.x6.nabble.com/Correlated-Subquery-Performance-tp5877p5886.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
