Every "a.project" statement results in a db.get() operation. Try to batch get() the project_key cache misses, and then set_multi() these in memcache.
Put/Copy the project.active and project.deleted booleans in the Action object. Then you can use them in the query and just fetch 25 Action objects that you need. You then have to update the booleans if you update a project, fetch all the Action objects with the right value "project.key()" for Action.project and set the booleans and batch put() them back. This is an operation that is less frequent then the user Action query. You can do the update with the task queue if there are a lot of Actions for a project. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---
