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

[John Doyle (JIRA)]

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

John Doyle updated TEIID-401:
-----------------------------

     Original Estimate: 2 weeks
    Remaining Estimate: 2 weeks
            Complexity: Medium


> 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
>
>   Original Estimate: 2 weeks
>  Remaining Estimate: 2 weeks
>
> 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