1

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....

Improve this question

1 Answer 1

Reset to default
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... 
}
Improve this answer
2
  • I will check and update you Commented Jan 17, 2015 at 4:55
  • Can you give me query? 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.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.