[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:comment-tabpanel&focusedCommentId=13444771#comment-13444771 ] 

Ramesh Reddy edited comment on TEIID-4918 at 8/6/17 8:01 PM:
-------------------------------------------------------------

I thought JDG cache store is a blob storage not sure if one of the load strategies is load from SQL query to work a Teiid view? Even then update is not straight forward, as it is not cache "put".

> There is also perhaps some way of by-passing puts/putall and writing directly to a store and then starting a cache in the materialization case.
Remote functions do give this ability to by pass the cache API, but it was not clear to me without spending more time and more over the Protostream stuff was another hurdle. Basically, the interaction will be

Teiid --> send a blob of data (say java serialization) --> wire to infinispan --> deseriliaze (java serilization) --> check for duplicate keys --> store in grid in protostream marshalled form

I saw too many things could be going wrong here, it may be better we work with Infinispan folks to drive to a correct solution.


was (Author: rareddy):
I thought JDG cache store is a blob storage not sure if one of the load strategies is load from SQL query to work a Teiid view? Even then update is not straight forward, as it is cache "put".

> There is also perhaps some way of by-passing puts/putall and writing directly to a store and then starting a cache in the materialization case.
Remote functions do give this ability to by pass the cache API, but it was not clear to me without spending more time and more over the Protostream stuff was another hurdle. Basically, the interaction will be

Teiid --> send a blob of data (say java serialization) --> wire to infinispan --> deseriliaze (java serilization) --> check for duplicate keys --> store in grid in protostream marshalled form

I saw too many things could be going wrong here, it may be better we work with Infinispan folks to drive to a correct solution.

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