Get answers quicker by searching

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

Viewing subscriber lists takes a very long time, minutes, when lists have more than 10K subscribers
  • Vote Up0Vote Down yaoquanyaoquan
    Posts: 36Sendy user
    Hi, I have 3 lists each with roughly 10k subscribers,and I have issues viewing subscribers list page. It takes a very long time and the server gets timed out. How can I resolve this?
  • 9 Comments
  • Vote Up0Vote Down yaoquanyaoquan
    Posts: 36Sendy user
    It seems to be the count functions in includes/list/main.php. How can this be fixed?
  • Vote Up0Vote Down yaoquanyaoquan
    Posts: 36Sendy user
    Also, adding an index on subscribers.list helped to speed things up
  • I have more than 10 lists with thoussands of addresses. Kind of a way to manage 10000 message limit, and segment the postings. The subscriber lists page often takes more than 20 seconds to load, and this is on a dedicated box.

    Indeed, having DB indexes would be a step in the right direction.
  • And after doing what @yaoquan says above, it's down to under 2 sec.
  • Vote Up0Vote Down BenBen
    Posts: 3,277Sendy support
    @nettiapina Do you mean the mySQL query in list.php?
  • I've not modified queries in any way. Index seems to do the trick for me.
  • Vote Up0Vote Down mattmatt
    Posts: 12Sendy user
    yeah... looking at the code.... it gets * for each list and then loops thru each one and gets count data for unsubscribes / bounces etc....

    when we have a large amount of data... it is one of those places you just hate to go... ( damn... I gotta go back into the list page )....

    WHAT IF

    you just show a the list of lists... and if we click the INFO button... then we can get updated info on that.... via AJAX

    AND

    what if you keep that data TOTALED in the LIST table and update if when an event happens to that list...

    LIKE

    someone unsubscribes from an email in that list... you update the LIST row in the LIST table ...

    WHAM

    that would be one of the fastest pages in the whole system...

    just a thought....

    m
  • Alternatively, you could simply 'SELECT COUNT(id) AS count FROM ...' and then simply have a single count value returned, an action which the database can perform much faster than actually querying and returning an entire dataset and then having to walk over that dataset to count the number of rows.
  • Vote Up0Vote Down BenBen
    Posts: 3,277Sendy support
    @nettiapina @matt @DrCocktor Thanks for the suggestions, will definitely change this.
This discussion has been closed.
All Discussions