Hi, Thanks for the patch! What about using a new cache type? The easiest solution is to replace the the 2Q algorithm with the soft reference cache; better would be to use a new type (for example SOFT).
> So I implemented cache using SoftReference. My prototype is attached. > It should be fine for read-only usage. What about combining it with LRU? So that written pages are kept in the LRU, and the read part is kept in the soft reference map? > Please try it with lot of memory free memory and read only scenario. > If it will be better then current cache I will continue and finish > implementation. I'm sorry, but I don't have much time to test it currently... But I'm sure it will be better than the current cache algorithm, because it doesn't require any settings and still will use all available memory. > I need motivation :-) If you like, we could call it the "Jan Kotek" cache :-) jdbc:h2:~/test;CACHE=JAN_KOTEK If you want to make integrating the patch simpler for me, I suggest you follow the patch guidelines described at http://www.h2database.com/html/build.html#providing_patches Regards, Thomas --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
