ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mhetea <mihaela.he...@gmail.com>
Subject SQL query is slow
Date Tue, 29 Aug 2017 09:09:32 GMT
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.

Mime
View raw message