Uploaded image for project: 'Openfire'
  1. Openfire
  2. OF-1622

Sub-optimal performance for Monitoring plugin

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Not a bug
    • Affects Version/s: 4.2.3
    • Fix Version/s: None
    • Component/s: Plugins
    • Labels:
      None

      Description

      Report from the forums:

      Monitoring plugin have a very strange code, that inserts messages into database.
      It select count of all messages from database with query: SELECT COUNT FROM ofMessageArchive
      Next, this number increased by 1, and inserted into database as “messageID” field.
      This code generates heavy load on database with huge number of archived messages and online users.
      For example - for me, query executes 3-4 seconds (SSD, MSSQL, 75 millions messages stored).
      Database can have autoincrement field, that works much faster.

      Though I don't know how easy it would be to retrofit an auto-increment field to all supported databases. It may be more practical to use a JiveID, for example. 

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            gdt Greg Thomas
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: