Optimización de índices en Magento 2: consejos + módulo Index Manager en un clic
Magento 2 Indexing: Modes, Performance, and Batch Size Optimization
Magento is a flexible and powerful comercio electrónico platform. But to ensure smooth performance, especially as your catalog grows, it’s essential to understand how Magento’s indexación system works. Indexes help Magento retrieve data faster, reduce the load on the database, and improve both frontend speed and backend operations.
En este artículo,’ll explain:
-
What Magento indexes are and why they matter
-
The difference between On Save and On Schedule indexación modes
-
How batch size affects indexación time and server performance
-
How the AdvancedIndexManager module le ayuda a manage indexes more efficiently
What Are Magento Indexes?
Magento uses several types of indexes to store pre-calculated data in dedicated tables. These indexes avoid heavy real-time database queries, which can slow down your site. Each index focuses on a specific area of your store.
Aquí están the main Magento indexes:
-
Product Price Index: Keeps product pricing up to date, especially when promotions or catalog price rules are applied.
-
Catalog URL Rewrites: Generates clean and SEO-friendly URLs for products and categories.
-
Category Products Index: Links products to categories to ensure fast loading of página de categorías.
-
Product Attribute (EAV) Index: Supports filtering and layered navigation, especially useful in large catalogs.
-
Catalog Search Index: Speeds up search results and improves accuracy.
-
Customer Group Price Index: Displays the correct prices for different customer segments, como wholesale or VIP customers.
Indexing Modes: On Save vs. On Schedule
Magento le permite choose between two indexación modes: On Save and On Schedule. Each has its advantages depending on how your store operates.
On Save
With this mode, indexes are updated immediately when you make changes to products, categories, or related entities.
Advantages:
-
Changes appear instantly on the frontend
-
Useful during promotions or campaigns where timing is critical
Disadvantages:
-
Can slow down the panel de administración, especially during large updates
-
May increase server load during peak activity
On Schedule
Here, indexación is handled by scheduled tasks (via tareas cron), usually every few minutes.
Advantages:
-
Reduces the load during product edits or imports
-
Maintains smoother performance for both backend and frontend
Disadvantages:
-
Changes are not reflected immediately
-
Requires a working cron setup
For most stores, On Schedule is the better long-term choice. It avoids unnecessary load during busy periods. On Save is better suited for short-term use when immediate updates are needed.
Why Batch Size Matters
Magento processes data in batches during indexación. The batch size determines how many items are processed in each cycle. This setting has a direct impact on how long indexación takes and how it affects your server.
-
A small batch size means longer indexación time, but with lower server impact.
-
A large batch size speeds up indexación but may consume more memory or cause timeouts on weaker servers.
Tuning the batch size for each index type can help you reach a better balance between speed and stability.
For example:
A store with 40,000 products reduced its indexación time by nearly 50% after increasing the batch size from 200 to 800, without affecting server performance.
Unfortunately, Magento doesn’t offer an easy way to adjust these values natively — and that’s where AdvancedIndexManager becomes useful.
Managing Indexes with AdvancedIndexManager
AdvancedIndexManager is a Magento 2 module designed to give you more control over how indexación works.
It le permite:
-
Adjust batch size per index to match your store’s capacity
-
View indexación logs to understand how long each index takes
-
Get suggestions for better batch size values basado en your data
-
Control everything from the panel de administración without using command-line tools
Esto es especially helpful if your store has thousands of products or frequent catalog changes. Instead of dealing with delays or server strain, you can configure your indexación to match your needs.
Conclusión
Magento indexación is a key part of your store’s performance and stability. Choosing the right indexación mode and setting an appropriate batch size can help you avoid unnecessary slowdowns and keep your store responsive.
With a tool like AdvancedIndexManager, you can take control of indexación without needing to dive into technical settings. Whether you're running a small shop or a large catalog, optimized indexación will make daily operations faster and more reliable.