Related products.

I'm sure that you're right about that being the bottleneck. Most likely, you don't need all of the data coming back from GetProduct, but you need more than you are getting from the search. My solution to this has been to add the extra fields that you need to the search options object you are executing the search with, and avoiding the conversion to a Product object altogether.

Ideally, you have a business-layer product object that wraps around the Commerce Server Product object. This wrapper can be created with a Commerce Server Product, or some subset of data instead. As it is used around the site, it will attempt to just work off of the subset of data it has. Only if some data is requested that is not in that subset, does it goes to the trouble of getting the actual Commerce Server Product object and incurring those costs.

When you perform your search, you create these product wrappers from the search results, feeding them the subset of the product data that you have and a null commerce server Product object. Then you use those wrappers throughout your site instead of the Commerce Server product object.

Of course, that's just one solution (lazy loading). I'm sure there are others, and the best fit will depend on your situation.

JaredHodges at 2007-10-2 >

My apologies, Kevin, I misunderstood your initial post! I will try to find some time later today to look into what you were really asking, but hopefully someone else will come along with a solution before then.

JaredHodges at 2007-10-2 >

Sudha Raghavan - MSFT wrote:

You can try using the ProductConfiguration class with the GetProduct method to load RelatedProducts initially. You can find more information onthe ProductConfiguration class at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sdkmref/html/T_Microsoft_CommerceServer_Catalog_ProductConfiguration.asp and more information about the GetProduct method with ProductConfiguration as an input parameter at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sdkmref/html/M_Microsoft_CommerceServer_Catalog_CatalogContext_GetProduct_2_e14b5ac9.asp A sample can be found at: http://msdn2.microsoft.com/en-us/library/aa545800.aspx Thanks Sudha

This makes a marginal imporvement but when I try to get the relationships for a whole catalog it still takes a long time. (12,000 relationship items in 870 seconds about 14 items(relationships)/second). Basically the small speed improvement is that I can get the variants from the Product class which is also the source for the related products. In other words i can use the Product class for both but I am guessing but it still takes a long time to construct the Product class.

Thank you.

Kevin

KevinBurton at 2007-10-2 >