Home / Tutorials / Optimization Database prestashop

Optimization Database prestashop


When you use prestashop in longtime

You want to Optimization database to make your site run faster

Please follow my guide

  1. back-up database

login back-office

Advanced Parameters > Database > DB Backup

create new back-up

2. login php-myadmin

run follow command

TRUNCATE TABLE ps_connections;
TRUNCATE TABLE ps_connections_source;
TRUNCATE TABLE ps_connections_page;


TRUNCATE TABLE ps_pagenotfound;

TRUNCATE TABLE ps_referrer;
TRUNCATE TABLE ps_referrer_shop;
TRUNCATE TABLE ps_referrer_cache;

TRUNCATE TABLE ps_statssearch;


TRUNCATE TABLE ps_smarty_cache;
TRUNCATE TABLE ps_smarty_last_flush;
TRUNCATE TABLE ps_smarty_lazy_cache;

DELETE FROM ps_search_index

WHERE id_product not in (select id_product from ps_product);

DELETE FROM ps_search_word

WHERE id_word not in (select id_word from ps_search_index);

OPTIMIZE TABLE ps_search_index;

OPTIMIZE TABLE ps_search_word;

About Leo Theme

Check Also

Leotheme Black Friday 2022

Prestashop Theme and Module Black Friday and Cyber Monday Sales Leotheme 2022 30% Off

Prestashop Leotheme Black Friday 2022 Promotion! Dear valued customers, Black Friday and Cyber Monday Sales …