[
https://issues.jboss.org/browse/TEIID-4918?page=com.atlassian.jira.plugin...
]
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)