Large Messages (1-2MB each)

  • Hi,

    I run a club website with around 350 members. I’ve hit a problem with send multiple large messages out. Each message is 1.5MB, as they have embedded images, and I’m queueing around 350 of them.

    There were 2 challenges – listing the queue and logs in the admin pages & the cron job.

    In both cases the code is fetching all columns and all entries – probably due to the amount of data crashing. However in both cases only a small proportion of the entries are used.

    I’ve fixed my issues (sort of) by adding a LIMIT 100 to each of the SELECT SQL statements. This does mean that admin queue only shows up to 100 entries, but it at least means it and the cron job work. (I’m not that bothered about the log display)

    The perfect fix would be the queue and the log display using OFFSET and LIMIT during pagination. The other fix would be to leave it all as is and only fetch the full Message text when the user wants it.

    The cron-job fix would be to either fetch the list without the message and then fetch each message separately.

    Thanks

    Dave

Viewing 1 replies (of 1 total)
  • Plugin Author WDM

    (@wdm-team)

    Hi Dave,

    I understand your problem. Good, that you’re able to quickfix it on your own. I never expected, that someone will queue such big emails ??

    We’ll take make up our mind about those issues in the next update of the plugin.

    Log:
    I guess, to request the message with ajax when needed, would be a good solution and solve your issue.

    Cron:
    Let us think about that one.

    I’ll keep you updated in a couple of weeks, when the next release is close. If you want, go to our website and send us a quick message with your contact, so we can have a testrun before the release.

    best,
    Nicolas

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.