Optimize DB

This topic has 1 reply, 2 voices, and was last updated 7 years ago by Stefano.

Viewing 2 posts - 1 through 2 (of 2 total)

Author

Posts
April 4, 2018 at 1:43 pm #84385

Roy
Participant

If there any way to optimise newsletter_sent table or delete old statistics that more tan 2 years old?

April 9, 2018 at 8:33 pm #85485

Stefano
Keymaster

You can use the timestamp in the table and run a delete query conditioned on that columns. The timestamp is the unix time, so your condition could me

field < unix_timestamp()-2*365*24*3600 Stefano.
Author

Posts

Check out our premium plans with priority support.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.