Commerce; Updating groups does not work if many purchases

[OctoDev]

I have a few products that has made several thousand sales.

When I am trying to update it, so it would update all existing purchases with a new user goup.. It seems like it only does the first 15 000 members, after that it seems to change 1 every 10-15 second, which makes it really slow and unusable.

Could this be fixed?

[Jim M]

Do you have an example I can take a look at? Which site is this for? Are you seeing any errors?

[OctoDev]

6 minutes ago, Jim M said:

Do you have an example I can take a look at? Which site is this for? Are you seeing any errors?

Sure, I just don't understand why I can't submit tickets anymore and only community support. Where can I send it?

[Jim M]

7 minutes ago, OctoDev said:

Sure, I just don't understand why I can't submit tickets anymore and only community support. Where can I send it?

You have all the normal options available to you via community support as you do via tickets. When creating a topic, you can select your license which the question applies to. You can provide us the domain here or message me. Along with any supplemental information.

[OctoDev]

On 4/7/2022 at 11:08 PM, Jim M said:

You have all the normal options available to you via community support as you do via tickets. When creating a topic, you can select your license which the question applies to. You can provide us the domain here or message me. Along with any supplemental information.

 

Sent you a message, not a big fan of this new system. I don't want to publicize my domain and sensitive info via a public thread.

[Jim M]

16 hours ago, OctoDev said:

 

Sent you a message, not a big fan of this new system. I don't want to publicize my domain and sensitive info via a public thread.

All this information typically would be selected from the options when creating a topic and then you would add access details to the Client Area like you normally would in a ticket. This way, you do not need to expose this data here.

I see you're utilizing CloudFlare for DDoS protection among other things, I would suggest disabling this as CloudFlare actually could be creating issues here.

[OctoDev]

3 hours ago, Jim M said:

All this information typically would be selected from the options when creating a topic and then you would add access details to the Client Area like you normally would in a ticket. This way, you do not need to expose this data here.

I see you're utilizing CloudFlare for DDoS protection among other things, I would suggest disabling this as CloudFlare actually could be creating issues here.

CloudFlare is not the reason to why it does 1 user every second. That does not make any sense.. Unless Invision Power requires 1 page load per 1 user, which would also not make any sense.

Personally I believe the issue is that it creates way too many steps.

 

I am positive it could do more than 100-200 users per request, i have no clue how many it does per request.. but it seems.. slow. It's the web requests starting to respond slowly, the rest of the website is instant.

 

It's creating thousands of step for a rather simple task.

 

Edited April 9, 2022 by OctoDev

[OctoDev]

I ended up having to code a custom PHP Script that would access the database, it completed the task that took several hours to do 5 000 members - in 20 seconds of execution. Moved +100 000 members into correct groups...

Hope this feature can be improved so it can actually be used in the near future.

[Marc]

Thank you for your feedback and glad you got what you needed there

[Stuart Silvester]

Thank you for your feedback, we've implemented some performance improvements (will be in a future update) for this process when large numbers of purchases need to be updated.