Bookshelf Home | Contents | Index | Search | PDF |
Siebel Marketing Guide > External Data Mapping > Joining Tables and Fields >
Guidelines for Caching
When defining joins, Siebel Marketing provides a Cache check box so that you can indicate if the table should be loaded into memory (cached) or accessed from a hard disk.
Use the following guidelines when deciding if you should cache a join.
- Do not load large tables into memory unless the server has sufficient physical RAM.
- Do not cache joins if the child table is mapped to the customer hierarchy. When a table is mapped to a hierarchy, the Marketing Server uses Merge functionality to retrieve the data.
- If the table is not mapped to a customer hierarchy and the table size is 10,000 rows and smaller, cache the join to reduce extract time.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Marketing Guide, Version 7.5, Rev. A Published: 18 April 2003 |