Uploaded image for project: 'Observium'
  1. Observium
  2. OBS-2508

Hame syslog housekeeping a bit more efficient

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Trivial
    • None
    • Professional Edition
    • None

    Description

      This little change makes the delete query and also the count much faster as the mysql function has only to be called once and not for every row.

      -$where = "UNIX_TIMESTAMP(`timestamp`) < $cutoff";
      + $where = "`timestamp` < FROM_UNIXTIME($cutoff)";

      Attachments

        1. syslog.diff
          0.4 kB
          Matthias Cramer

        Activity

          People

            landy Mike Stupalov
            cramer Matthias Cramer
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: