Preformance decay on Magento search - Eav model flaw?
Hi all,
Has anyone else faced this issue with Magento search?
I am running my store on 512 MB RAM and have a catalog of around 4000 products. Now on the search I observe that the more the products, the slower the search. On looking at it further, I guess, the Magento attempts to load all attributes of all the search results.
Explaining further, if my search results in 100 hits, Magento seems to be loading all the search related attributes of all the hundred products which seems to be a time consuming process. Ideally Magento should only retrieve the attributes of the products displayed on the page.
Had anyone else faced/investigated this issue?
Moreover Magento being based out of EAV model offers little scope of optimization on search what with all those attributes being queried from various sources and is this not an architecture constraint on Magento to improve its search capabilities? Has Magento sacrificed performance for flexibility?
1salsasepp posted Sat, May 10, 2008
Did you read the recent blog about Visions http://www.magentocommerce.com/blog/comments/inteview-alpediade-on-magento/ ? ("extremely fast new search function").
Someone else is having that issue.
2salsasepp posted Sat, May 10, 2008
Thanks for pursuing this (saw your bug report)!