Gabriel Corneanu wrote:
Following a few other discussions, I had the feeling that sqlite should benefit from a cache which discards cached pages in a least frequently used order.
Just offhand, classical LRU is quite poor in terms of lock overhead. The CLOCK refinement scales much better, because no reorganizing of LRU lists is needed during page references.
And of course, having gone thru all of these exercises of fancy application-level cache algorithms already, it's still obvious that the best approach is to leave it to the kernel.
-- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.org/project/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users