I have stuck at one thing. we need to fetch data data form Magento and generate the FEED.

The Problem is that we have around 40,000 products around 715 attributes and around 950 attribute set. one more the I need all filterable attributes in this collection.

When i try to call the Product collection as per default Magento Standard then It will take too much time on server as well as data.

How to optimize the query....

1 Answer 1


If you do it like this (below) you should not eat all the resources and then fall over. It will still take a fairly long time due to the size of the dataset but will attempt to "Eat the elephant one bite at a time" instead of all at once !!

$query = $this->_getReadAdapter()->query($select);
while ($row = $query->fetch()) {
 //process row
 add to your feed or whatever... 
  • I will check and update you
    – Keyul Shah
    Commented Jan 17, 2015 at 4:55
  • Can you give me query?
    – Keyul Shah
    Commented Jan 25, 2015 at 2:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.