Page Comparison

See also the 2.11 release guide for improvements included in the 2.11 release: 2.11 Release Guide - Performance Improvements Phase I

UPDATE (2/22): For the most current recommendations, please see Scaling for Flash Sales, Product Launches, and other Web Events.

Considerations already implemented

...

Static Cache Guidelines

1. 24 Hours:

   1. MetaDataTags -> 24 hours

   2. ProductMetaDataTags 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 no longer 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