I am wondering if there is any way we could implement more intelligent caching system into Hypersonic. It's nice that you can at least set the number of rows to be cached, but in some cases, some rows could end up taking 10 bytes of memory, while others takes 10,000 bytes of memory. So a database where you cache 3*2^14 rows could end up taking either 480kb of memory, or 480MB, depending on the sizes of the rows.
I would propose that we set a cache limit based on the actual number of characters in each of the Strings that we are caching. That way, you could tell Hypersonic to cache a maximum of 64 Megabytes of Strings in memory, or 32 million characters, or whatever, and it would stay within those limits, instead of just telling it how many rows to cache, which has a huge variation in size.
I'm wondering if there's any current mechanism for doing this, how much work it would be, and I'm also offering to help (if it doesn't take too much knowledge about the caching system to implement). Thanks!
-Jeff Hansen [EMAIL PROTECTED]
_________________________________________________________________
Getting married? Find tips, tools and the latest trends at MSN Life Events. http://lifeevents.msn.com/category.aspx?cid=married
-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
_______________________________________________
hsqldb-developers mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
