Form Caches: Difference between revisions
(Created page with '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 -- An Overview | Custom Re...') |
|||
| Line 5: | Line 5: | ||
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. | 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== | ==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 [[Form Storage Mechanisms|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 | |||
[[Category: Technical Overview]] | [[Category: Technical Overview]] | ||
Revision as of 13:39, 27 August 2009
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
