[Dbix-class] Resultset with memcached

[sindharta_tanuwijaya at yahoo.co.jp]

Hi,

Thanks for your response. I also saw your post here:
http://grokbase.com/post/2007/11/22/catalyst-dbic-v-cache-what-are-catalyst-best-practices-for-caching-dbic-results-with-relationships-included/vXQc8SjXITu1G9Lf4RD_-ZJLTZQ

which gave some insight and at the same time raised some questions in my head. First, I realized that there was a mistake in my code, the current one that is working looks like this

..
..
    if ( $data = $c->cache->get($cache_key) ) 
    {        $data->result_source($c->master->schema()->source('table_schema_name'));
    }
    else
    {
      $data =
        $c->master->resultset('table_schema_name')->search( 
          \%search_condition,
          {
            prefetch => 'table_relations',
          }
        );
      $c->cache->set( $cache_key, $data );
    }
    $data = $data->first;
..
 ..
 
And reading Matt S Trout's posts there, I suppose that there are actually two types of caching:
- per query cache (database)
- object construction cache 

And I also assume that the object is constructed by using methods like "search" and the query is performed by using methods such as "first", like what Hartmaier had said, and thus, the caching that I am trying to implement now is the object construction caching. Please correct me if I am wrong
 here.

Then, I tried to test if this caching can actually make the response time faster by using Benchmark::Timer, but I was surprised to find out that most of the time, performing "search" is a little bit faster than getting the value from the cache.

Actually, I think that the bottleneck in my case here is the time it takes to perform database queries. I haven't tried DBIx::Class::Cursor::Cached yet, but looking at the posts, it seems more appropriate for me than  Cache::Memcached. Any thought how long a value will stay (valid) inside the
 cache in DBIx::Class::Cursor::Cached ?

Sindharta


Tobias Kremer <list at funkreich.de> wrote: >  Couldn't render template "undef error - Can't call method "source" on an
> undefined value at
> /usr/lib/perl5/site_perl/5.8/DBIx/Class/ResultSourceHandle.pm line 64.

You lost your ResultSource. This is normal when storing ResultSets in a cache
AFAIK. Use DBIx::Class::Cursor::Cached (works great) or reset th
ResultSource after fetching your data from the cache. If my memory serves you
can do that like this:

my $rs = $c->cache->get( 'cachekey' );
...
$rs->result_source( $c->model( 'MyModel' )->source( 'result_source_classname' )
);

Maybe there is an even simpler way ...

HTH

--Tobias

_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.rawmode.org

 

 
---------------------------------
Easy + Joy + Powerful = Yahoo! Bookmarks x Toolbar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20080110/3652f15c/attachment.htm