[teiid-issues] [JBoss JIRA] (TEIID-4918) Enhance infinispan support for muti-threaded puts or using putAll

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy resolved TEIID-4918.
---------------------------------
    Resolution: Done


Based on feed back, I turned off the default Bulk Insert feature. If one want to use "putAll" based bulk insert, then the VDB needs to enable the capability by translator override like 

{code}
    <translator name="over-hr" type="infinispan-hotrod">
        <property name="supportsBulkUpdate" value="true"/>
    </translator>
{code}

then use the source hint in the query as below. Note that in the below query in the hint, the "localhost" is the name of the "source" in the VDB for Infinispan model.

{code}
insert /*+sh localhost:'use-putall' */ into G1 (e1, e2, e3) values (2, 'two', convert(2.0, double)), (3, 'three', convert(3.0, double));
{code}

> Enhance infinispan support for muti-threaded puts or using putAll
> -----------------------------------------------------------------
>
>                 Key: TEIID-4918
>                 URL: https://issues.jboss.org/browse/TEIID-4918
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Infinispan
>    Affects Versions: 9.3, 8.12.x-6.4
>            Reporter: Van Halbert
>            Assignee: Ramesh Reddy
>             Fix For: 10.0
>
>
> For performance reasons, it was requested that the infinispan connector/translator be enhanced to be multi-threaded when doing batch inserts or try using the putAll option.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)