Home › Forums › Newsletter Plugin Support › Optimize DB

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
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.