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

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.