We have a cache with ~3million entries
We execute the following query:
select count(_key) from IgniteProduct as product where POSITION
('Z',manufacturerCode)>0
The query takes about 7s though the index is hit.
Query execution is too long [time=7103 ms, sql='SELECT
COUNT(PRODUCT__Z0._KEY) __C0_0
FROM "productCache".IGNITEPRODUCT PRODUCT__Z0
WHERE POSITION('Z', PRODUCT__Z0.MANUFACTURERCODE) > 0', plan=
SELECT
COUNT(PRODUCT__Z0._KEY) AS __C0_0
FROM "productCache".IGNITEPRODUCT PRODUCT__Z0
/* "productCache".IGNITEPRODUCT_MANUFACTURERCODE_IDX */
WHERE POSITION('Z', PRODUCT__Z0.MANUFACTURERCODE) > 0
, parameters=[]]
, parameters=[]]
Can somebody help/offer an alternative?
--
View this message in context:
http://apache-ignite-users.70518.x6.nabble.com/SQL-query-is-slow-tp16475.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
