BUG - Delayed profile save during cupid mail queue

Hi, 

 

When a user has a lot of matches and cupid notification is enabled, it can take a very long time for that user to save their profile. This is because dolphin is queuing up the match emails to send. This queue processing should be sent to the cron process and not hold up a user's browsing experience. It took over 1.5 minutes to save a profile that in turn queued 16k emails.

 

Thanks

Quote · 13 Apr 2013

Can this get logged?

Quote · 16 Apr 2013

bump... 

Quote · 18 Apr 2013

bump...

Quote · 23 Apr 2013

:(

Quote · 25 Apr 2013

Emails are queued and can't cause delays, delay (most probably) is caused by matches calculation. 

I would recommend to limit matches calculation per one run.

in inc/match.inc.php file:

$aProfiles = $oDb->getColumn("SELECT `ID` FROM `Profiles` WHERE `Status` = 'Active' AND `ID` != $iProfileId $sCondSort LIMIT 1000");

 

Theoretically, since the result is cached, next time it will process another set of members and so on, so it shouldn't stop on the first 1000 members.

Rules → http://www.boonex.com/terms
Quote · 26 Apr 2013

I'll try that. Buy while the save was occuring, I was refreshing the mailq and I could see it increasing. Does calculation and queuing occur in tandem?

Quote · 26 Apr 2013

 Upon saving, if there are matches, then emails about matches are added to the mail queue.

I'll try that. Buy while the save was occuring, I was refreshing the mailq and I could see it increasing. Does calculation and queuing occur in tandem?

 

Rules → http://www.boonex.com/terms
Quote · 29 Apr 2013

this additional bit of code "LIMIT 1000" seems to stop most cupid mail now... Where a profile update once created 16k mails... it now only created 6-700...

Quote · 29 Apr 2013
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.