Photo Organizer

Notice: Undefined index: tasklist_type in /var/www/flyspray/includes/class.tpl.php(128) : eval()'d code on line 85 Notice: Undefined index: tasklist_type in /var/www/flyspray/includes/class.tpl.php(128) : eval()'d code on line 90
  • Status Closed
  • Percent Complete
  • Task Type Feature Request
  • Category Backend / Core
  • Assigned To No-one
  • Operating System All
  • Severity Low
  • Priority Normal
  • Reported Version 2.33
  • Due in Version Undecided
  • Due Date Undecided
  • Votes 0
  • Private No
Attached to Project: Photo Organizer
Opened by Solomon Peachy (pizza) - 2007-10-26
Last edited by Solomon Peachy (pizza) - 2008-06-26

FS#298 - Add support for memcached

It's basically a distributed key=value service. entirely In-RAM. (What happens when it fills? LRU?)

Initially, cache things that don't chagne often -- like usernames and folder names/parents but on a random photo page load, we have to hit several times.

This isn't a big deal now, but on high-traffic sites it can make quite a difference in performance.

Adding general support for this is a bit more complicated, as it would have to sit inbetween the querys and the database, so I'd rather just add it to a few hotspots as needed.

This task does not depend on any other tasks.

Closed by  Solomon Peachy (pizza)
Thursday, 26 June 2008, 20:18 GMT
Reason for closing:  Implemented
Additional comments about closing:  There's always room for improvement, but the first parts are there. The search/folder browse improvements are a much more complex problem.
Solomon Peachy (pizza)
Friday, 26 October 2007, 17:31 GMT
There's an official PHP extension -- php-pecl-memcache.

We could also use it to store session info.
Solomon Peachy (pizza)
Friday, 26 October 2007, 17:46 GMT
-devel now allows one to specify a memcache session handler, or one can just use the default PHP stuff which of course can be memcache.
Solomon Peachy (pizza)
Monday, 26 November 2007, 04:08 GMT
the default config file now includes a memcache example. I have it running on the peachy photography site, and it rocks.
Solomon Peachy (pizza)
Tuesday, 18 March 2008, 14:58 GMT
Initial candidates for caching:
*) userid -> info [un,fn,ln] (called once per page and almost never changes)
*) folderid -> info (and/or 'get_path_to_folder' cache)
*) albumid -> info (and/or 'get_path_to_album' cache)
*) photoid -> keywords
*) photoid -> tech_info


*) Search results -- the search query return everything, and it gets cached for a short time. we page back and forth from the cache.
Solomon Peachy (pizza)
Thursday, 26 June 2008, 19:50 GMT
userid ->info added
locationid -> info added
get_users_folder, get_users_album added
photoid->keywords added
get_path_to_folder, get_path_to_album added