[
https://issues.jboss.org/browse/ISPN-3937?page=com.atlassian.jira.plugin....
]
Dan Berindei commented on ISPN-3937:
------------------------------------
We need to also look at the other tricks Hibernate uses in its
SpecializedMySqlStringCacheStore:
http://pastebin.com/4w0mAf65
E.g. there is another issue to use REPLACE INTO for MySQL:
https://issues.jboss.org/browse/ISPN-686
Investigate the memory usage of JDBC cache stores when processing a
large result set
------------------------------------------------------------------------------------
Key: ISPN-3937
URL:
https://issues.jboss.org/browse/ISPN-3937
Project: Infinispan
Issue Type: Task
Components: Core, Loaders and Stores
Affects Versions: 6.0.0.Final
Reporter: Dan Berindei
Assignee: Dan Berindei
Fix For: 7.0.0.Final
Iterating over a huge ResultSet with MySQL seems to keep all the rows in memory:
https://community.jboss.org/message/854402
We should investigate whether we can limit the memory usage to a fixed amount and whether
this affects other drivers as well.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira