[WITH FIX] Slow sending when big broadcast/many contacts

  • rens23

    (@rens23)


    1 year, 2 months ago

    Problem:

    Slow sending when the number of contacts increase.

    Cause:

    Slow database updates when updating the wp_ig_sending_queue table, due to missing index on contact_id column.

    Solution:

    Create a index on the column “contact_id” in the database table wp_ig_sending_queue

    Query:

    CREATE INDEX contact_id_idx ON wp_ig_sending_queue (contact_id);

    Speed improvement:

    Before: 4 seconds per email

    After: 0.8 seconds per email

    • This topic was modified 1 year, 2 months ago by rens23.
Viewing 1 replies (of 1 total)
  • Plugin Contributor Shubhanshu Kandani

    (@shubhanshukandani)

    1 year, 2 months ago

    Hi @rens23,

    Hope you’re doing well.

    Thanks for sharing your suggestion with us and pointing it out! We have included it in the roadmap. We will improve it in the upcoming releases of our plugin.

    Let me know if you have any other feedback or doubts related to the plugin. 

    I would be glad to assist you further if you need it. 

    Thanks a lot.

Viewing 1 replies (of 1 total)
  • The topic ‘[WITH FIX] Slow sending when big broadcast/many contacts’ is closed to new replies.