[ https://issues.apache.org/jira/browse/IGNITE-4490?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15858072#comment-15858072 ]
Alexander Paschenko commented on IGNITE-4490: --------------------------------------------- [~vozerov] No, this issue is not concerned with {{_key}} or {{_val}}. It's about any columns and cases when the user provides values for them as literals (either in query string or via statement params) and no additional computations needs to be done to evaluate expressions and functions. As I wrote in my comment above: {quote} What has changed: when query contains no expressions, just constants and parameters, and insert is done in rows based manner, then such query is processed in a way similar to fast UPDATE and DELETE. {quote} > Optimize DML for fast INSERT and MERGE > -------------------------------------- > > Key: IGNITE-4490 > URL: https://issues.apache.org/jira/browse/IGNITE-4490 > Project: Ignite > Issue Type: Improvement > Components: SQL > Affects Versions: 1.8 > Reporter: Alexander Paschenko > Assignee: Alexander Paschenko > Fix For: 2.0 > > > It's possible to avoid any SQL querying and map some INSERT and MERGE > statements to cache operations in a way similar to that of UPDATE and DELETE > - i.e. don't make queries when there are no expressions to evaluate in the > query and enhance update plans to perform direct cache operations when INSERT > and MERGE affect columns {{_key}} and {{_val}} only. -- This message was sent by Atlassian JIRA (v6.3.15#6346)