Home Forums Newsletter Plugin Support Optimize DB

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #84385
    Roy
    Participant

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

    #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.

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.