Hi,

I am looking into frameworks for a site build, my concern is caching
for one particular call. I looked in this group but could not find an
exact answer.

Background
In any event, the site uses a hodge podge of freely available
government databases (or db tables created from xls files) There are
essentially two sets of data that are joined via "crosswalk" tables.
Unfortunately, these tables are huge.

Long story short:
The site calls for one particular query for each item id that is built
by querying 5 joined tables. (3 for data and two as the afore mention
'crosswalks'). This query takes about 5 seconds to run, so obviously I
want to cache each unique view i.e. (/jobs/item/1234) for 24 hours. I
read the manual and it seems like I need to explicitly tell the
controller what id/views to cache, am I right, or will cake simply
cache all dynamically generated views automatically?

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to