ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vladimir Ozerov (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-5482) Implement basic caching of query results
Date Thu, 13 Jul 2017 15:46:00 GMT

    [ https://issues.apache.org/jira/browse/IGNITE-5482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16085893#comment-16085893
] 

Vladimir Ozerov commented on IGNITE-5482:
-----------------------------------------

One more thing - it is illegal to cache results if query contains non-deterministic functions,
such as CURTIME(). See MySQL reference as example: https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html
This makes previous comment about enabling cache manually with {{false}} as default the only
viable option for now.

> Implement basic caching of query results
> ----------------------------------------
>
>                 Key: IGNITE-5482
>                 URL: https://issues.apache.org/jira/browse/IGNITE-5482
>             Project: Ignite
>          Issue Type: Task
>          Components: sql
>    Affects Versions: 2.0
>            Reporter: Alexander Paschenko
>            Assignee: Alexander Paschenko
>              Labels: important
>             Fix For: 2.2
>
>
> Sergi suggested that we reuse results of the same queries running simultaneously - i.e.
if a query is being executed with the same arguments and flags again and again, there's no
need to do actual querying of data, instead we can really run query once while other simultaneous
runs will wait for those results.
> This strategy will be implemented on MAP stage of distributed query.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message