Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-48003

Incoming email processing seems relatively expenseive

    XMLWordPrintable

Details

    • Bug
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 2.8
    • FRONTEND
    • Libraries
    • MOODLE_28_STABLE

    Description

      It struck me that 40 db queries to reject these meessages semed like a lot - should investigate if it scales:

      Scheduled task: Incoming email pickup
      Connecting to mail.moodle.com as posts@moodle.org...
      Connection established.
      Searching for Unseen, Unflagged email in the folder 'INBOX'
      Found 2 messages to parse. Parsing...
      - Parsing message 4
      -- Subject:	im evil
      -- From:	t.j.hunt@open.ac.uk
      -- Recipient:	posts+AAAAAAAAAAIAAAAAAAAAAgAAAAAAAAAK6JGVs7QiTMf/8XOs@moodle.org
      -- Processing the message as user 2 (admin).
      -- Message did not meet validation but is possibly recoverable. Fail code 256
      --> Sending a message to the user to report an verification failure.
      --- Original message retained on mail server and confirmation message sent to user.
      -- Returning to the original user.
      - Parsing message 5
      -- Subject:	Dan is evil
      -- From:	mary@moodle.com
      -- Recipient:	posts+AAAAAAAAAAIAAAAAAAAAAgAAAAAAAAAK6JGVs7QiTMf/8XOs@moodle.org
      -- Processing the message as user 2 (admin).
      -- Message did not meet validation but is possibly recoverable. Fail code 256
      --> Sending a message to the user to report an verification failure.
      --- Original message retained on mail server and confirmation message sent to user.
      -- Returning to the original user.
      ... used 40 dbqueries
      ... used 2.8588440418243 seconds
      Task completed.
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              poltawski Dan Poltawski
              Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Sara Arjona (@sarjona)
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated: