Form Caches

The data for a form XXXXX may be cached into a table hippo_XXXXX. This hippo table can be used for:

• To generate reports to Custom Reporting
• To export data for decentralized data management

Hippo Table Structure

If a form XXXXX has a field YYYYY then the hippo_XXXXX table will have a column `XXXXX+YYYYY.` There is also a column `XXXXX+id` containing the id of the form and a column `XXXXX+parent` containing the parent form, if any.

Cache Times

The hippo tables are generated by a background process once a form cache is consider stale. The background process is spawned by default every 10 minutes. This can be specified by setting the value in magic data at:

• /modules/CachedForms/times/background

The stale time for a report defaults to 10 minutes. This can be over-ridden by the following setting values in magic data:

• /modules/CachedForms/times/stale
• /modules/CachedForms/times/stale_time_by_storage/ZZZZZ
• /modules/CachedForms/times/stale_time_by_form/XXXXX

where ZZZZZ is the storage mechanism that form XXXXX uses.

The background process will, in general, only update changed forms in the hippo_XXXXX table. However, once a certain amount of time (one day by default) has passed, the hippo_XXXXX table is completely dropped and rebuilt. You can change this time by specifying the value at

• /modules/CachedForms/times/recache_time