[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 resolved TEIID-3849.
-----------------------------------
    Resolution: Done


Implemented the update enhancements which check the connection for v2 support.  Also updated to use the asynch api - except for the result set, which could be added if needed.

The batching is currently implemented in a single call, but that may need to be split depending upon the volume that is being written.

> 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)