sitecore7 - Designing a Sitecore tree to store more than 1Mn items -
i have 300+ "category" (can go 4 sub levels) items , 1mn+ "product items" stored in sitecore database. designing sitecore content tree.
i considering 2 options,
option1 - model "category" --> sub category .... --> "product items"
option 2 - model "category" tree separately , have "product items" separately. (home -> categories -> cat 1...
) , (home -> product items -> product items
)
according experience if go option 1, painfully slow if need modify category items , publish. (even enhancements)
option 2 not create balanced tree, category nodes faster edit.
please me sort out this. using sitecore 7
.
you more or less going have come solution storing in separate section of content tree. not advise place million+ product items sitting directly under individual category items. number of reasons, including:
- performance, say. changes categories happen often, "follow market", "seo reasons". "campaign categories" (like "summer sale 2014") bound pop time time
- the nature of category/product relationship 1 1. meaning same product can , exist in multiple categories (think: duracell batteries existing in both "electrical", "batteries - non-rechargeable" , "camera accessories" categories)
since you're on sitecore 7, built-in solution product repository put products item bucket. have 2 (obvious) choices building product/category relationship:
- on "product", set multilist field named "categories", , add id of each category item product belongs to
- on "category", set search field select products item bucket
it depends on how product hierarchy going managed, of above fits best.
information on item buckets here: http://sdn.sitecore.net/reference/sitecore%207/developers%20guide%20to%20item%20buckets%20and%20search.aspx
Comments
Post a Comment