ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From davida <david.alezan...@live.com>
Subject Ignite sub queries performance
Date Sun, 19 Feb 2017 18:47:29 GMT
Noticed that ApacheIgnite.NET SqlFieldQueries support nested queries, but
after experimenting a bit found that some take too long to complete (testing
on local machine, Reflective serialization, KPICache.GetSize()=10000
objects, all properties/fields are basic types).

Should nested queries be avoided in general (e.g. I can use scan queries or
split this queries) ?

"select ID, Date, Origin, Destination, EmptyDays, LoadedMiles from KPIDetail
where ID in (select LoadedMiles from KPIDetail where TotalMiles > 7000)"

"select ID, Date, Origin, Destination, EmptyDays, LoadedMiles from KPIDetail
where ID in (select distinct TerritoryID from \"SalesCache\".SalesOrder
order by TerritoryID asc)"

Subquery in 2nd case is executed very fast (there is no many objects in
cache SalesOrder ~30K) ~ 125ms: "select distinct TerritoryID from
\"SalesCache\".SalesOrder order by TerritoryID asc"

Thanks.



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Ignite-sub-queries-performance-tp10720.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Mime
View raw message