Optimization Database prestashop

Hi

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_log;

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_mail;

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;