On 2012-06-14 10:52, Eoin Byrne wrote:
Is there any guidance on what the max number of lobs I can bring back
per ResultSet? It it related to a cache size?
The number of CLOB / BLOB values that are cached on the server is now
the maximum of: 5 times the SERVER_RESULT_SET_FETCH_SIZE (which is 100
by default), and SysProperties.SERVER_CACHED_OBJECTS.
One other thing to mention for others who might hit this issue is that
turning off MVCC seems to have fixed the bloated file problem, with
MVCC enabled the DB is around 450 MB after the tests and I get that
"DB Closed" error message after the "Missnig LOB". Without MVCC the
DB is about 70 MB at the end of the tests with no "DB Closed" errors
however I am getting a number of table lock timeouts now.
Yeah, in general MVCC mode is still experimental. I would not use it for
production work.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
