Chris C. did some tests with memcached and it seems it's a great way to improve perfs of Koha. However, it requires some code changes. And an additionnal software installed on the server (memcached is provided on debian, and mandriva -contrib-, so it's probably not a true problem) I suggest that we add memcached option to Koha 3.2. Here could be a start for RFCs : - add a syspref usecached, to use or not memcached - memcache reference tables. I see the following reference things : context, sessions, userflags, permissions, language_*, systempreferences. Most of them are useed everytime a page is loaded in Koha (staff or opac) - memcache some other tables, that are often used : branches, itemtypes, auth_types, biblio_framework, categories, cities, ethnicity, opac_news "Memcaching" a reference table means modifying the GetTable() sub to check if the cache is already filled or not for this table : if ($usecache) { require Cache::Memcached; Cache::Memcached->import(); $memd = new Cache::Memcached( 'servers'=>['127.0.0.1:11211'], ); my $result = $memd->get("koha:reftable"); if ($result){ return $result; } else { $result = <retrieve result from SQL>; $memd->set("koha:reftable", $result, 300); # 300 : expire after 300 seconds. Can be set to more } } If you agree with this proposal, i'll add it to RFC for 3.2 pls comment. -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : 04 91 31 45 19 _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel