PERFORMANCE · SQL
Advanced PreLoaders.
Same data, fewer queries.
- Who it helps
- Stores with heavy listing and product pages.
- What changes
- Redundant collection queries are cut at the database level, with no template or frontend changes.
- Fewer collection queries on PLPs and PDPs
- No changes to layout XML, JS or HTML output
- No rewrites, observers or plugin spaghetti
Boost backend performance in Magento 2 by reducing SQL query load on PLPs and PDPs. qoliber Advanced PreLoaders minimizes database calls by up to 80%—Hyvä-safe and built for scale.
Compatible
Hyvä
Compatible
ElasticSuite
Compatible
Mage-OS
v 2.6.2 — RELEASED 2 months ago
composer require qoliber/preloaders
Product details
Advanced PreLoaders – High-Performance SQL Optimization for Magento 2
qoliber Advanced PreLoaders is a backend optimization module designed to drastically reduce SQL queries on Product Listing Pages (PLPs) and Product Pages (PDPs). Built for high-traffic Magento 2 environments and large catalogs, this extension enhances platform stability and scalability without affecting frontend rendering.
Leveraging smart collection preload logic, it minimizes redundant queries by up to 80%—keeping your database lean and fast under load. No rewrites, no hacks — just clean, dependency-free architecture that plays nicely with custom themes, headless stacks, and Hyvä-based builds.
80% Fewer SQL Queries
Reduces collection queries on PLPs and PDPs using efficient preload logic. Same data, dramatically less overhead. Ideal for stores with thousands of products.
Backend Performance Gains
Cuts page load times at the database level, improving performance without frontend refactoring. No template changes required.
Built for Hyvä & Custom Stacks
Compatible with Hyvä Themes, Luma, and headless setups. Safe to use in both monolith and decoupled architectures. Zero JS conflicts.
Clean, Developer-Centric Architecture
No rewrites, observers, or plugin spaghetti. Designed for Magento 2 tech teams who value performance, readability, and clean integration.
Scales With Your Store
Perfect for enterprise merchants, agencies, or merchants running large-scale catalogs. Works out-of-the-box, no extra tuning required.
No Frontend Impact
Backend-only logic. Doesn’t modify layout XML, JS, or HTML output. CWV safe and deployable without re-theming or staging breakage.
WHAT IT FIXES
Redundant SQL, preloaded away.
Product listing and product pages run redundant collection queries. Advanced PreLoaders uses collection preload logic to cut them at the database level — backend-only, with no template changes and no change to frontend output.
- Fewer collection queries on PLPs and PDPs ● preloaded
- No changes to layout XML, JS or HTML output ● backend-only
- No rewrites, observers or plugin spaghetti ● clean
- Hyvä, Luma and headless setups ● compatible
- Works out of the box, no extra tuning ● zero config
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/preloaders php bin/magento setup:upgrade ✓ Installed. Updates arrive with composer update.
FROM THE COMMUNITY
Customer reviews
Write a review
Write Your Own Review