Fixed Huge load time when updating usergroup's permissions

[account8226]

Hello,

When I update my members usergroups (more than 200K members), it's taking ages, and after like 30 seconds I got the following error :

Fatal error: Maximum execution time of 30 seconds exceeded in /home/darnkzz55/public_html/library/Zend/Db/Adapter/Mysqli.php on line 110

I'm on a dedicated server with 8GB ram. I don't know how it's working, but I think XenForo is updating every user's permission combination ID field, so that's why it's taking ages ?

 

[Mike]

Not exactly, but it is updating a lot of records. 1.2 handles this rebuilt a bit differently so it can be broken up but it still can be an extensive process.

In the mean time, you may just want to increase your PHP timeout.

 

[account8226]

Not exactly, but it is updating a lot of records. 1.2 handles this rebuilt a bit differently so it can be broken up but it still can be an extensive process.

In the mean time, you may just want to increase your PHP timeout.

Great thanks for the awnser, but since there was this PHP error, do you think every members permissions were updated ?

 

[Mike]

Unlikely. You should save the changes again.

 

[account8226]

Ok thanks you.

 

[account8226]

Not exactly, but it is updating a lot of records. 1.2 handles this rebuilt a bit differently so it can be broken up but it still can be an extensive process.

In the mean time, you may just want to increase your PHP timeout.

I can confirm this as fixed in 1.2. I can know update more than 150k members' permissions a lot quicker (like 10 seconds).