[Koha-devel] memcached and v3.2

[Paul POULAIN]

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 at lists.koha.org
http://lists.koha.org/mailman/listinfo/koha-devel