ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From javadevmtl <java.dev....@gmail.com>
Subject Re: Btw anyone heard of CQ engine?
Date Thu, 17 Sep 2015 18:39:07 GMT
This is the type of queries I run to do the analytics I need. It may seem
crazy. But it is, what it is... :)

String unionPrefix = "UNION SELECT \"" + CACHE_NAME + 
"\".MyExtPrimModel._key, \"" + CACHE_NAME +  "\".MyExtPrimModel._val FROM
MyExtPrimModel ";

String sqlStr = "SELECT * FROM MyExtPrimModel WHERE field1 = ? "
+ unionPrefix + "WHERE field2 = ?"
+ unionPrefix + "WHERE field3 = ? "
+ unionPrefix + "WHERE field4 = ? "
+ unionPrefix + "WHERE field5 = ? "
+ unionPrefix + "WHERE field6 = ? "
+ unionPrefix + "WHERE field7 = ? "
+ unionPrefix + "WHERE field8 = ? "
+ unionPrefix + "WHERE field9 = ? ";

If we can squeeze out even more performance and make ignite even faster then
awesome.



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Btw-anyone-heard-of-CQ-engine-tp1421p1447.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Mime
View raw message