redrum Posted December 16, 2021 Share Posted December 16, 2021 (edited) I have looking around for information about empty unnecessary database tables to optimize the database. Some people say that it is safe to empty the table ps_guest, and some people say that it probably should be left untouched. Since I don't know every function, feature and process that grabs data from the ps_guest-table, I'm hoping for some inputs here. Will there be any loss of functions if I run the query below? $query = 'DELETE FROM ps_guest WHERE id_customer = 0 AND id_guest NOT IN (SELECT id_guest FROM ps_cart) AND id_customer NOT IN (SELECT id_customer FROM ps_customer)'; Edited December 17, 2021 by redrum (see edit history) Link to comment Share on other sites More sharing options...
Knowband Plugins Posted December 20, 2021 Share Posted December 20, 2021 We want to tell you that the multiple modules use the ps_guest table data and if the data is deleted then it causes issues. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now