[teiid-issues] [JBoss JIRA] Commented: (TEIID-401) Increase performance of XML-Relational connectors file cache

[Ramesh Reddy (JIRA)]

    [ https://jira.jboss.org/jira/browse/TEIID-401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12469615#action_12469615 ] 

Ramesh Reddy commented on TEIID-401:
------------------------------------

I know we centralized the caching, such that it is very easy for us to distribute this cache contents, can you also see if there was any performance improvement with this implementation, compared to last versions when you get sometime?. I think that would be helpful validate this work too. Also, I have not done any perf checks on JBoss cache checks myself. Thanks.

> Increase performance of XML-Relational connectors file cache
> ------------------------------------------------------------
>
>                 Key: TEIID-401
>                 URL: https://jira.jboss.org/jira/browse/TEIID-401
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: XML Connector
>    Affects Versions: 6.0.0
>            Reporter: Marc Shirley
>            Assignee: John Doyle
>             Fix For: 6.1.0
>
>
> I-T 248339.  XML-Relational File Connector has severe performance issues when forced to use file caching on Linux/Solaris OS.  When using only the in-memory cache, the sample query in 248339 takes around 10 seconds.  When using the file cache, the query takes around 270 seconds to complete.  The sample data file source in 248339 consumes around 25MB of memory, so the default memory cache setting of 16MB forces the file cache to be used.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira