Optimize database

1920_1080_201009161257271012259OOP

As the years pass, the databases are filled with important information and less important information that may not even know it exists and not interested at all.

If you are not familiar with statistics prestashop and also do not interest you, you can leave much lighter your database by emptying the contents of the following tables:

ps_connections
ps_connections_page
ps_connections_source
ps_guest
ps_page_viewed

Executing the following statements directly in the database:

truncate table ps_page_viewed;
truncate table ps_connections_page;
truncate table ps_connections_source;
truncate table ps_connections;
truncate table ps_guest;

Posted on 01/03/2014 in Prestashop

Share the Story

Leave a reply

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

Back to Top