ntriga/pimcore-optimize-db-tables

Optimize the database tables in messages

11.0.0 2024-09-06 12:00 UTC

Requires

• php: ^8.1
• pimcore/pimcore: ^10.0|^11.0

MIT

• Vincent Bibauw

• mysql
• optimize
• pimcore
• ntriga

README

OPTIMIZE TABLES to save sace in DB

Features

• Objects: Uses messages to optimize the DB tables

Installation

You can install the package via composer:

composer require ntriga/pimcore-optimize-db-tables

Add Bundle to bundles.php:

return [
    Ntriga\OptimizeDbTables\OptimizeDbTablesBundle::class => ['all' => true],
];

Add a cronjob to run the command, we do this every night:

0 2 * * * /path/to/your/pimcore/bin/console ntriga:pimcore-optimize-db-tables

Consume the messages

bin/console messenger:consume ntriga_optimize_db_table

Further configuration

For more information about the setup, check Setup

Changelog

Please see CHANGELOG for more information on what has changed recently.

Credits

• All contributors

License

GNU General Public License version 3 (GPLv3). Please see License File for more information.