The last update 1.85 skyrocketed the number of mysql queries

Are you using Onesignal or Firebase. Last update 1.85 is related to frontend settings control when Onesignal is used for push notification. This will use sql only when Frontend settings are enabled. Other than that there is no other changes except for new installation create table query change to make it compatible with MYSQL 8.0 but if you already using this plugin this create table will not be executed as table are already defined. Please send me screenshot of error. I have already included demo site in the admin area using WordPress playground and some more demo sites for this plugin demo site1 i tested all changes for onesignal in this site and for firebase push i tested in another site. I will try to add some more conditions for onesignal push so that if frontend settings are not enabled it will not check the db table for subscription option. This update is almost ready, i will release it today

• This reply was modified 7 months, 1 week ago by Murali.

I have released another update 1.86 version, it will optimize queries. If user has older version of plugin prior to 1.65 then it will execute necessary queries related to latest changes in PNFPB table other wise those queries will not run. Please download 1.86 version and let me know comments. I have also verified using query monitor.

• Optimize SQL logic in function PNFPB_update_database to execute only for older version of this plugin version less than 1.65.
• BuddyBoss users – Frontend push notification settings for various notifications are available under user profile – account – push notification subscription, users will be able to control notifications for Firebase/Onesignal push notifications.
• Onesignal push notifications updates based on Frontend notifications settings. If Frontend settings are switched off then notification will be sent to all users for general BuddyPress activities/comments. For group activities,it will be sent only to group users based on frontend settings ON/OFF. Similarly other notifications will work according Front end settings enabled/disabled and based on user subscription settings.

I use Firebase with more than 98 thousand divece tokens, and after version 1.86 it seems that the problem was solved. I monitor and if something strange appears I will let you know. Thanks as always for the quick response.