Extremely slow startup when using product categories

Hi,

While waiting more then 15 minutes now for the startup of our application I found time to make this post.

We have a solution with products in product groups and product categories linked to those product groups. Somehow the first time we start our application fresh it creates the following text nodes in the globalsettings file:

  <Ecom>
    <ProductCategoriesLanguageControl>
      <Language>
        <H05.E>True</H05.E>
        <G21.A>True</G21.A>
        <G21.B>True</G21.B>
        <G21.C>True</G21.C>
	....... LOTS MORE LINES HERE
      </Language>
      <Variant>
        <H05.E>True</H05.E>
        <G21.A>True</G21.A>
        <G21.B>True</G21.B>
        <G21.C>True</G21.C>
 ....... LOTS MORE LINES HERE
      </Variant>
    </ProductCategoriesLanguageControl>
  </Ecom>

Two questions about this:

1) Why? (All the info is available in the database, which is the primairy source)

2) Why is generating this file for 209 product categories in 4 languages taking more as 20 minutes?

Greets Hans

Developer forum

Extremely slow startup when using product categories

Replies