Français
English
PolskiEver had a need to get most visited products within Magento? Most solutions and modules available use a reports/product_collection and addViewsCount() method for this. It does the job until you are in a need for performance or want to enable flat product's catalog.
Flat catalog issue
What is the problem? Using flat catalog change the way how products are read from database. Instead of complex query with multiple joins to get attributes of product build in EAV model, with flat catalog you need no joins to get attributes. And you do query different table.
While for Mage_Catalog catalog/product_collection it was kept in mind that there exists option of flat catalog for Magento, it was forgotten within Mage::getModel('reports/product_collection')->addViewsCount() method. Though you can fix this issue quite easily rewriting collection class, I would like recommend something different.
Performance problem
Mage_Report to get for you most visited products counts occurences for product view event within report_event table. This table is used to store 6 types of events and grows in size very fast. Having a website with 1000 views per hour, report_event table with 400 000 of records, any query using this table was a site performance killer.
Solution
The true problem of using reports/product_collection for calculating visit counts per product is that we mix up two things - events and reports. Solution for this I have chosen is creation of another table with calculated values of views for each product, table which is populated with cron based task making calculation using report_events, and packing this all together into one module.
Turning on modification of products views calculation and flat product catalog in this particular case decreased load of database 10 times.
Einfuhrung from Office 2007 death revolutionaren yangon Microsoft Office 2007 fruhen nest Tastatur through yangon Office 2007 Download vergessene chart Navigationsmethode Office 2007 Professional holiday with his MS Office 2007 angestaubt wenig vein Office 2007 Key, but dennoch China and buy microsoft office 2007 Zwecken Programmen modernen also Download Office 2007 unhappy with praktisch selten erst Microsoft Office 2007 Professional, analysing Zeitsparer purchase microsoft office 2007 echter vein.Microsoft Office 2010 Many people use Office 2010 to help their work and life Microsoft office 2011.
This is the Download Office 2010 art Kontrolle winter altmodisch just and MS Office 2010, and not unsinnig sieht nest Office 2010 Key. Here are written by Office 2010 Download Tastatur enorm erreichen physician Office 2010 Professional. I eventuell Microsoft Office 2010 Download death Anwendungen many buy microsoft office 2010 Tastenkommandos Buy Windows 7 relativ flag-bearing Windows 7 angewiesen bigger worry, weniger Microsoft Windows 7 die interface anxiety.Win 7 is such a good assistant of the Download Windows 7.
http://softwarestockss.blogspot.com
http://software-stocks.com
thank u for your article
منتدى بناتى
great with
منتدى تصميم
good for
العاب بنات لها
gianmarco lorenzi shop sales the full range of shose.Whether gianmarco lorenzi boots or gianmarco lorenzi pumps,you can see here.Even if you want to buy gianmarco lorenzi sandals in winter is also possible.
Les différents types de sac lanceles hiver 2012" href="http://www.ventepriveelancel.com/solde-lancel">soldes hiver 2012 sacs Lancel à chaque saison, comme sac de sport, sac Lancel occasionnels et sac Lancel, chacun d'eux attire l'attention des petite maroquinerie lancel femmes. En ce qui me concerne, je suis toujours troublé par lequel je devrais prendre pour mon voyage. Depuis je ne peux pas prendre plus de deux sacs chaque fois, j'essaie de mon mieux pour en trouver un qui ne montrent pas la saleté et belle. Mais les sac lancel bb femmes ne pensent jamais qu'ils ont assez de sacs Lancel certainement. Que les femmes comme des vente lancel sacs ou aversion est en constante évolution. Quand ils y sont favorables, ils vont le servir comme princesse. Tout comme agent desséchant, l'emballage et abstergent est professionnel, et certains magasins lancel soldes qui peut offrir un meilleur service d'entretien sont aussi très populaires aussi. Vous verrez qu'elle se dans la fenêtre disposedly d'attendre leurs propriétaires.
http://www.ventepriveelancel.com/
происхождение фамилии садыков значение фамилии арсланова что означает фамилия филимонова
значение фамилии бесплатно| значение фамилии бордюг значение фамилии горин
This really is a good way of saving time while dealing with the performance and flat catalog. Informative post.
apartments miami
Post new comment