PHPackages                             justbetter/magento2-optimizeflattable - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. justbetter/magento2-optimizeflattable

ActiveMagento2-module[Database & ORM](/categories/database)

justbetter/magento2-optimizeflattable
=====================================

Module for optimizing Magento flat table generation

1.0.2(1y ago)34.6k↑471.4%4MITPHPPHP >=8.2CI passing

Since Mar 28Pushed 1y ago4 watchersCompare

[ Source](https://github.com/justbetter/magento2-optimizeflattable)[ Packagist](https://packagist.org/packages/justbetter/magento2-optimizeflattable)[ RSS](/packages/justbetter-magento2-optimizeflattable/feed)WikiDiscussions master Synced today

READMEChangelog (3)Dependencies (4)Versions (6)Used By (0)

JustBetter OptimizeFlatTables
=============================

[](#justbetter-optimizeflattables)

In Magento 2 when you want to index many text fields to the flat tables you could run into the `Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help.` error.

The reason being every field taking up length for 255 characters while this is often not used.

This module aims to reduce the chance of this happening by checking the product attributes with backend type `varchar` used in the flat table, and determine the actual length of the column. Instead of taking the default value of `255`.

Installation
------------

[](#installation)

Run

```
composer require justbetter/magento2-optimizeflattable
```

After enabling the module your problems indexing to the flat tables should be resolved!

###  Health Score

40

—

FairBetter than 86% of packages

Maintenance48

Moderate activity, may be stable

Popularity28

Limited adoption so far

Community16

Small or concentrated contributor base

Maturity58

Maturing project, gaining track record

 Bus Factor2

2 contributors hold 50%+ of commits

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~224 days

Total

3

Last Release

380d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/2d00b3f55cd4ae8b8cfb001a644ed6c7a1127a956c24375bcfe16ce12bd89bed?d=identicon)[justbetter](/maintainers/justbetter)

---

Top Contributors

[![BobWez98](https://avatars.githubusercontent.com/u/23509926?v=4)](https://github.com/BobWez98 "BobWez98 (4 commits)")[![rbnmulder](https://avatars.githubusercontent.com/u/1227535?v=4)](https://github.com/rbnmulder "rbnmulder (3 commits)")[![indykoning](https://avatars.githubusercontent.com/u/15870933?v=4)](https://github.com/indykoning "indykoning (1 commits)")[![royduin](https://avatars.githubusercontent.com/u/1703233?v=4)](https://github.com/royduin "royduin (1 commits)")

###  Code Quality

Static AnalysisPHPStan

Type Coverage Yes

### Embed Badge

![Health badge](/badges/justbetter-magento2-optimizeflattable/health.svg)

```
[![Health](https://phpackages.com/badges/justbetter-magento2-optimizeflattable/health.svg)](https://phpackages.com/packages/justbetter-magento2-optimizeflattable)
```

###  Alternatives

[smile/elasticsuite

Magento 2 merchandising and search engine built on ElasticSearch

8064.7M49](/packages/smile-elasticsuite)[mollie/magento2

Mollie Payment Module for Magento 2

1131.9M16](/packages/mollie-magento2)[swissup/module-search-mysql-legacy

Legacy mysql search for magento 2.4

10489.1k](/packages/swissup-module-search-mysql-legacy)[run-as-root/magento2-prometheus-exporter

Magento2 Prometheus Exporter

68357.9k](/packages/run-as-root-magento2-prometheus-exporter)[mage-os/module-automatic-translation

Automatic AI content translation for Mage-OS.

3017.9k](/packages/mage-os-module-automatic-translation)[buckaroo/magento2

Buckaroo Magento 2 extension

32420.3k8](/packages/buckaroo-magento2)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)