1 Topic by iain

  • iain
  • Veteran
  • Offline
  • Registered: 19-01-2009
  • Posts: 91

Topic: cache_tables

Hi Again

I was going to use things like cache_occurrences and cache_termlists_terms as a way to populate some of my lists in a more fastly manner. But, there's no data in them for some reason - is this maybe because I'm using asp.net - I thought all this would happen on the warehouse, sort of behind the scenes but maybe not. Thing I've looked at are

indicia/modules/cache_builder/helpers/cache_builder.php (actual code for building tables)
indicia/application/config/config.php (MODPATH.'cache_builder' is there)
indicia/applicatiojn/models/occurrence.php (which seems to do the call to build the occurrence cache)

Can anyone shed a wee bit of light on what I might be missing here. Is there a 'don't build cache tables' switch somewhere that I've missed?

Any thoughts?

Ta

Iain

2 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: cache_tables

Hi Iain
Presuming that you have the cache_builder module installed, since you have the tables, the other thing you will need to do is periodically run the scheduled_tasks link. For more info see http://indicia-docs.readthedocs.org/en/ … tasks.html

This should then populate the tables for you. If you have a lot of records already, you might need to run it a few times to get it to process everything.

Cheers
John

John van Breda
Biodiverse IT

johnvanbreda's Website

3 Reply by iain (edited by iain 23-04-2013 08:47:24)

  • iain
  • Veteran
  • Offline
  • Registered: 19-01-2009
  • Posts: 91

Re: cache_tables

Thanks John,

Yup, that's the bit I was missing, I'll give that a go

Ta

Iain

EDIT - Tried it, working fine