Appendix B: Site Cache Guidelines

Owned by Sarah Holst
Oct 28, 2021
1 min read

Static Cache Guidelines

  1. 24 Hours:

    1. Product Classifications (ProductMetaDataTags) -> 24 hours

  2. 30 Minutes:

    1. ProductAttribute -> 30 min per product

    2. TerminalConfiguration -> 30 minutes

  3. By Setting:

    1. Inventory pools (Get Inventory For Month call) -> "ecommercesettings.productinventory.cachetime"

      1. NOTE: In the 2.12 release, coming in late October, inventory will be enhanced so it is retrieved from RTP|ONE less frequently, which will improve performance for inventoried products. 

    2. Dynamic pricing tables: yieldPriceListTable, yieldProductVariantTable, yieldDaysToArrivalTable -> "ecommercesettings.dynamicpricing.cachetime"

    3. Product Inventory (golf specific): -> "GolfSettings.ProductInventory.CacheTime"

  4. Logical:

    1. If catalog setting "CacheProductPrices" is set to true product prices are cached for 60 seconds

  5. 60 Minutes:

    1. ActivityLogType

    2. Category

    3. Category API Call (this call loads the category pages and PDP pages)

    4. CheckoutAttributes

    5. Currency

    6. Customer Household Information (name, birthdate, address, media codes, and gender, legacy contact id)

    7. CustomerRoles

    8. Discount

    9. DiscountRequirement

    10. Does a product have an attribute y/n (cached so we don't call the db to get attributes if the product doesn't have any)

    11. Languages

    12. LocalStringResource (language strings)

    13. LocalizedProperty

    14. PermissionRecord

    15. Picture (table)

    16. ProductCategory

    17. ProductManufacturer

    18. Settings

    19. SpecificationAttribute

    20. SpecificationAttributeOption

    21. Store (holds url and language info)

    22. StoreMapping

    23. TaxAddress

    24. TaxRate

    25. Url RecordsWidgets