[teiid-issues] [JBoss JIRA] (TEIID-3849) Writes using Cassandra connector are very slow

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-3849:
----------------------------------
    Fix Version/s: 9.0


The translator currently does not support bulk/batched updates and yes just uses standard CQL to issue an INSERT/UPDATE/DELETE.   So at the least we'll update the logic to support bulk updates and it looks like the batch logic is via BatchedStatement.  The change to asynch would be useful to not tie up a Teiid thread.

> Writes using Cassandra connector are very slow
> ----------------------------------------------
>
>                 Key: TEIID-3849
>                 URL: https://issues.jboss.org/browse/TEIID-3849
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Misc. Connectors
>            Reporter: Pranav K
>            Assignee: Steven Hawkins
>             Fix For: 9.0
>
>
> The connector seems to execute the insert queries one by one rather than using batched approach, also the API used is the synchronous one instead of the future based async API [session.executeAsync()]
> Cassandra writes are generally very fast, but it was noted in one scenario that on a single node Cassandra setup inserting a set 50k records and 3 columns took more than 25 mins.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)