Performance fix for EAV module

This module is a performance fix for all community and enterprise versions before 1.9.

Since I worked for a store having very complex products (with a large number of attributes and large scale of values), I discovered that Magento has a performance bottleneck on the product listing page and product page.

By having a closer look at the class Mage_Eav_Model_Entity_Attribute_Source_Table you can observe that getOptionText method use

 $options = $this->getAllOptions(false);

which is getting all records from the database and then filter them like this:

  foreach ($options as $item) {
            if ($item['value'] == $value) {
                return $item['label'];

This module will be useful for Magento shops with products with a large number of attributes or/and a large scale of values.

Download the module hereĀ