Add benchmarks and memory information

[paales]

Since the module's main fix is performance, it should present some numbers about the achieved performance.

Out of interest, we have a shop with 500k products (8 storeviews) and currently have product URL's disabled, what does the module do in terms of memory consumption?

I can do some tests with it, but if you already have they lying around...

[SchumacherFM]

Looking also forward for some test results.

[mklooss]

in the Dev Branch is a small Bench. https://github.com/mklooss/Loewenstark_UrlIndexer/blob/dev/Bench.md

the new Resource::_getProducts Method saves ~ 0.2 seconds per Request... https://github.com/mklooss/Loewenstark_UrlIndexer/blob/dev/app/code/community/Loewenstark/UrlIndexer/Model/Resource/Url.php#L75

so the major changes to the magento indexer are

• Option for: do not create url index for disabled and/or visibility:hidden products
• also removed category path from url, can configured by magento url indexer, but the entries will be generate
• my table "urlindexer_url_rewirte" only provides categorie rewrites, so you can speed up the left join request for eg. the main navigations. (in my case i had 1.5 Mio Products and the left join take a long time after reindexed the url table...) https://github.com/mklooss/Loewenstark_UrlIndexer/blob/master/app/code/community/Loewenstark/UrlIndexer/Helper/Category/Url/Rewrite.php

PS: if you need categorie path in url, you have to take a look at ecomdev/urlindexer

[SchumacherFM]

Hey Mathis,

you probably have recognized that your optimization in the helper Helper/Category/Url/Rewrite.php is only available in Magento CE >= 1.8.

[mklooss]

you are right in magento <= 1.7.0.2 it is directly in the collection :/ Mage_Catalog_Model_Resource_Category_Collection::joinUrlRewrite -> rewrite Mage_Catalog_Model_Resource_Category_Flat::_loadNodes -> may via event Mage_Catalog_Model_Resource_Category_Flat::getParentCategories -> rewrite Mage_Catalog_Model_Resource_Category_Flat_Collection::addUrlRewriteToResult -> rewrite

so its only resolve able via a rewrite