PrestaShop keeps connections, connections_page, connections_source, guest and thousands of abandoned carts in the database. Every visit, every page view, every cart that never became an order adds rows. On busy shops these tables can grow to hundreds of thousands of records—slowing down queries, backups, and the back office.

You don't need that data forever. Old visitor stats are rarely used if you rely on Google Analytics. Abandoned carts that never converted can be removed safely. Clearing them frees space and often improves response times. The problem is doing it safely: you must not touch carts that have orders, and you should know exactly what you're cleaning.

Database Optimization gives you a single back-office screen with one switch per table. You see how many records will be removed and when each table was last cleaned. You choose what to clean and click once. Carts: only those with no associated order are deleted. Statistics tables: truncated. No core hacks, no SQL by hand—just a free addon that keeps your store lean.