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.
