PERFORMANCE · INDEXING
Optimized Indexers.
Shorter reindex windows.
- Who it helps
- Stores whose reindex time grows with the catalog.
- What changes
- Selected native indexers are replaced with bulk implementations, which shortens reindex windows.
- Optimized mode: production-safe replacement for native logic
- Bootstrap mode: CSV + LOAD DATA INFILE for full rebuilds
- Bulk operations, pre-computed lookups and batching
Optimized Indexers for Magento 2 is a set of performance-focused indexing modules designed to significantly reduce reindexing time in Magento 2 stores.
The solution targets one of the most common bottlenecks in Magento installations: slow and resource-heavy catalog indexing.
The module provides two alternative indexing strategies - Optimized and Bootstrap - that can be used depending on the environment and use case, while preserving full data consistency with native Magento indexers.
Compatible
Hyvä
Compatible
Mage-OS
v 2.5.0 — RELEASED 3 months ago
composer require qoliber/optimized-indexes-metapackage
Product details
Optimized Indexers for Magento 2
Optimized Indexers for Magento 2 by qoliber is a performance-focused extension designed to significantly reduce catalog reindexing time in Magento 2 stores. It replaces selected native Magento indexers with optimized implementations built to process large datasets efficiently and predictably.
The extension is designed for both Magento 2 developers and merchants. Developers gain faster and more reliable indexing workflows, while merchants benefit from a faster and more responsive store, shorter maintenance windows, and smoother catalog updates. By reducing database load during indexing operations, the module helps keep the storefront responsive even during intensive catalog changes, directly supporting uninterrupted sales.
Why native Magento indexers become a bottleneck
Native Magento indexers rely heavily on EAV joins, per-product processing, and repeated database queries. As catalogs grow, reindexing time increases rapidly and database load becomes difficult to control. For merchants, this often results in slower backend operations, longer deployments, and visible slowdowns on the storefront.
Optimized Indexers for Magento 2 redesign this process by using bulk operations, pre-computed lookups, and efficient batching strategies. This approach scales linearly with catalog size and delivers predictable performance, allowing stores to grow without sacrificing speed or stability.
Measured performance improvements
Benchmark run date: 2025-12-23
Benchmark dataset
- 67,950 products
- 2,113 categories
- 4 stores, 2 websites
- 11 customer groups
- ~5.9 million index rows
Total reindex time
- Native Magento: 251 seconds
- Optimized mode: 92 seconds
- Bootstrap mode: 47 seconds
- Up to 5.3× faster
Operational impact
Faster indexing shortens deployment time, reduces maintenance windows, and lowers database contention. For merchants, this means fewer slowdowns during business hours, faster catalog updates, and a storefront that remains responsive even during intensive operations.
Business value for merchants
Optimized Indexers for Magento 2 directly supports daily store operations by making catalog changes visible faster and without performance degradation. Product updates, price changes, and stock adjustments are processed more efficiently, keeping the storefront responsive.
Reduced database load during indexing helps maintain consistent storefront performance during peak activity periods. This leads to smoother shopping experiences, lower bounce rates, and better conditions for conversion-driven campaigns.
Shorter maintenance windows and faster deployments mean fewer interruptions to sales. Merchants can scale their catalogs and operations with confidence, knowing that performance will remain stable as the business grows.
Indexer modes and recommended usage
Optimized
Production-safe mode that replaces native logic with optimized implementations. Ideal for everyday store operations, helping merchants maintain fast backend processes without affecting storefront availability or customer experience.
Bootstrap
High-performance mode based on CSV generation and LOAD DATA INFILE. Best suited for development environments and planned maintenance, where maximum speed is required to rebuild large catalogs quickly.
Important: Bootstrap indexing is disabled in production mode by default. It temporarily truncates tables and drops secondary indexes. For live stores, the Optimized mode should be used to ensure continuous sales and stable store performance.
Who this extension is for
- Merchants who want faster store operations and better storefront performance
- Magento 2 developers working with medium and large catalogs
- Agencies optimizing deployment speed and CI/CD workflows
Optimized Indexers for Magento 2 by qoliber is a practical investment for merchants who want a faster, more stable Magento store and for teams that need predictable indexing performance without modifying Magento core behavior or introducing operational risk.
WHAT IT FIXES
Native indexers, rebuilt for bulk.
Native Magento indexers rely on EAV joins, per-product processing and repeated queries, so reindexing slows down as the catalog grows. Optimized Indexers replaces selected indexers with implementations built on bulk operations, pre-computed lookups and batching — keeping data consistent with the native indexers.
- Optimized mode: production-safe replacement for native logic ● production
- Bootstrap mode: CSV + LOAD DATA INFILE for full rebuilds ● maintenance
- Bulk operations, pre-computed lookups and batching ● architecture
- Data consistency with native Magento indexers ● preserved
- Shorter deployments and maintenance windows ● ops
- Bootstrap disabled in production mode by default ● safe
INSTALL · COMPOSER
One composer line.
Your license adds the package to your private qoliber repository. Add the repository once, then require the package like any other dependency — no ZIP files, no copying folders into app/code.
# Once per project: add your private qoliber repository # (the exact command is in your account → Composer & keys) composer require qoliber/optimized-indexes-metapackage php bin/magento setup:upgrade ✓ Installed. Updates arrive with composer update.
01Do you provide technical support for implementing qoliber extensions?
We do not provide support for the implementation of our extensions, as we are not familiar with the specific business, code, or processes of each client. For this reason, we rely on development agencies to handle the customization and integration, ensuring a smooth and tailored implementation for each store.
02Are qoliber extensions open-source?
Our extensions are offered under a commercial license with partial access to the source code, allowing for some customizations. However, full ownership remains with qoliber, and any modifications must comply with our licensing terms.
03What are the technical requirements for installing qoliber extensions?
Our extensions require a Magento-based environment, proper PHP versions, and compatibility with solutions like Hyvä and ElasticSuite, depending on the specific integration. Full technical requirements can be found in the documentation, helping you prepare the environment prior to installation.
04Can I modify qoliber extensions to suit my specific business needs?
Yes, our extensions are designed to allow modifications, but we recommend working with experienced Magento developers who understand the platform and the complexities of integrating with solutions like Hyvä and ElasticSuite. Modifications may affect future updates and support.
05How often are qoliber extensions updated?
We release regular updates to accommodate Magento platform changes, fix bugs, and introduce new features. Keeping our extensions secure and optimized is a priority, so we encourage clients to regularly update to the latest version as soon as it becomes available.
06Does qoliber offer refunds if the extension doesn't perform as expected?
Yes. You can get a full refund within 30 days of the first purchase of any licence, no questions asked. Renewals are non-refundable.
07Can I gain early access to beta versions of new qoliber extensions for Magento?
For selected partner agencies, we offer access to beta versions of our new extensions. If your agency is interested, please contact us to learn more about our partner programme and early access.
08What is the update policy for qoliber extensions in Magento?
We regularly release updates that include bug fixes and feature enhancements. Agencies should monitor for new releases and ensure that client stores are updated regularly to maintain the security and stability of the extensions.
FROM THE COMMUNITY
Customer reviews
Write a review
Write Your Own Review