Magento is a pretty powerful and complex system. It allows to work with massive amounts of data, but when database is overloaded with tons of records it becomes heavy and slow. Magento uses indexes to solve this problem. Indexes are additional database tables with some flat data, which allows to organize fast responses from the database. By default, core system updates indexes on each item’s save. But in some cases you need to do it manually, for example some types of mass actions etc.

As many of you know, at the end of the last year Magento have introduced an opportunity to the developers to confirm and leverage their knowledge of Magento by passing the Magento Developer Certification. Here we’d like to share some thoughts on the preparation process basing on our experience.