[ https://issues.apache.org/jira/browse/IGNITE-6843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vladimir Ozerov updated IGNITE-6843: ------------------------------------ Labels: iep-1 performance (was: ) > SQL: optionally do not use WAL when executing CREATE INDEX > ---------------------------------------------------------- > > Key: IGNITE-6843 > URL: https://issues.apache.org/jira/browse/IGNITE-6843 > Project: Ignite > Issue Type: Task > Security Level: Public(Viewable by anyone) > Components: sql > Affects Versions: 2.3 > Reporter: Vladimir Ozerov > Labels: iep-1, performance > Fix For: 2.4 > > > When index is being created through {{CREATE INDEX}} command, every single > index update is written to WAL. Let's introduce special mode where updates > are not written to WAL: > 1) Index updates are not written to WAL > 2) When index is ready, force checkpoint and wait for it to happen > 3) Purge index data if node crashed before checkpoint > Alternatively, we may even not trigger a checkpoint, hoping that that node > will not crash before the nearest checkpoint is finished. If node crashed > during this time window, index should be marked as "invalid", and not used > for queries. Then user should either re-create or rebuild it. -- This message was sent by Atlassian JIRA (v6.4.14#64029)