From: Andy S. <an...@gm...> - 2008-07-30 20:08:10
|
On Wed, Jul 30, 2008 at 12:30 PM, Jesse Mullan <jm...@vi...> wrote: > (dang it, this went just to any by accident) > > On Wed, Jul 30, 2008 at 2:30 PM, Jesse Mullan <jm...@vi...> wrote: > > That's 2 queries plus a LOT of complex joins followed by various PHP > > manipulations of the data, right? If one indexed query doesn't yield > > much speedup, then why would there be speedup for file-based caching? > Joins based on the integer primary key column are complex? It's more expensive than select from a single table on PK, but I think that our ORM isn't that heavy when just loading entities. And the PHP code that follows isn't heavy either. Anyhow, that's just a detail. I think that this specific caching backend "new cache table with single column for serialized entity object replacing GalleryStorage::loadEntities()" is not where you can get the biggest bang for the buck. I'd be happy to get convinced by numbers. :) We should focus on removing the disk based entity cache for loadEntitiesById() calls with more than 1 id. Not sure if we can remove the disk baed entity cache completely. We need to focus on adding memcached/APC support. We need to find out why our page cache isn't that great yet (it's pretty heavy for some users). We might have to kill the session based permission cache. If you want to work on the DB, the imageblock code is still a bit heavy. Or the itemAttributesMap (view counting) could benefit from changes. - Andy > > > > > On Wed, Jul 30, 2008 at 2:07 PM, Andy Staudacher <an...@gm...> > wrote: > >> @per entity db cache: > >> An entity can be fetched with 2 queries. > >> 1. get entity type from store. > >> 2. single select with lots of table joins to get the whole data set for > a > >> single entity. > >> > >> I doubt that this is an area where we need to spend time for > optimizations. > >> > >> As for modularizing the cache layer and adding memcached/APC/... > support: > >> Sure, we all agree on that. > > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > __[ g a l l e r y - d e v e l ]_________________________ > > [ list info/archive --> http://gallery.sf.net/lists.php ] > [ gallery info/FAQ/download --> http://gallery.sf.net ] > > |