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