Title: Massive database value
Last modified: January 11, 2020

---

# Massive database value

 *  ResolvedModerator [Jose Castaneda](https://wordpress.org/support/users/jcastaneda/)
 * (@jcastaneda)
 * THEME COFFEE MONKEY
 * [6 years, 4 months ago](https://wordpress.org/support/topic/massive-database-value/)
 * Hi there!
 * Earlier today we had a site go down because there was a database query that was
   running for some time. Part of that was because the query being run was
 *     ```
       UPDATE wp_optionsSEToption_value= 'MASSIVE BLOB OF TEXT' WHEREoption_name= 'cron'
       ```
   
 * When I went to look at the current value, the array had 26,076 entries attached
   so I can see why things would be super slow. I wanted to expand it but Sequel
   Pro halted when I tried to select it 😱.
 * What I'm wondering is how is that db value being fully utilized and what are 
   some steps that can be taken to reduce this down the line?
 * Thanks!
    -  This topic was modified 6 years, 4 months ago by [Jose Castaneda](https://wordpress.org/support/users/jcastaneda/).
      Reason: fix code

Viewing 5 replies - 1 through 5 (of 5 total)

 *  [Sygnoos Support](https://wordpress.org/support/users/sygnoossupport/)
 * (@sygnoossupport)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/massive-database-value/#post-12319727)
 * Dear [@jcastaneda](https://wordpress.org/support/users/jcastaneda/),
 * We do have crons in our plugin, but as it’s general for other plugins as well,
   we would like to make sure those records refer to our plugin or not.
 * We are just wondering if you have the latest (3.59) version of our plugin?
 * Can you send us the massive log so we can see if there are any records related
   to our plugin?
 *  Moderator [Jose Castaneda](https://wordpress.org/support/users/jcastaneda/)
 * (@jcastaneda)
 * THEME COFFEE MONKEY
 * [6 years, 4 months ago](https://wordpress.org/support/topic/massive-database-value/#post-12321846)
 * It is the latest version and this was the screenshot I was able to get; it does
   show that the sgpbGetNotificaions event was being created many times over
 * [https://www.dropbox.com/s/7kxvv4n1pahx9hg/image.png?dl=0](https://www.dropbox.com/s/7kxvv4n1pahx9hg/image.png?dl=0)
 * It was super strange to see that and I have no idea what could have really caused
   that to behave that way either.
 *  [Sygnoos Support](https://wordpress.org/support/users/sygnoossupport/)
 * (@sygnoossupport)
 * [6 years, 4 months ago](https://wordpress.org/support/topic/massive-database-value/#post-12323236)
 * Dear [@jcastaneda](https://wordpress.org/support/users/jcastaneda/),
 * We used to have problems with crons in the past, but we have fixed them in our
   latest versions. And if you’re using the latest version of our plugin as well,
   the issue should have been fixed for you as well.
 * Please, deactivate/reactivate the Popup Builder plugin on your side then check
   via Sequel Pro if our plugin crons are cleared. There should be only one left
   with this name: “sgpbGetNotifications”.
    This should solve your issue.
 * If these steps don’t solve the issue, please, download the WP Crontrol plugin.
   It will show the active crons on your site.
    If our crons show, you can delete
   them (‘sgpbGetNotifications’).
 *  Moderator [Jose Castaneda](https://wordpress.org/support/users/jcastaneda/)
 * (@jcastaneda)
 * THEME COFFEE MONKEY
 * [6 years, 4 months ago](https://wordpress.org/support/topic/massive-database-value/#post-12326252)
 * Ah, good to know.
 * They wound up switching to a different solution.
 * Again, not sure what really could have caused this to spring up like that. There
   had been no changes in code in nearly a week.
 * Appreciate the helpful replies to this 😊
 *  [Sygnoos Support](https://wordpress.org/support/users/sygnoossupport/)
 * (@sygnoossupport)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/massive-database-value/#post-12327580)
 * Dear [@jcastaneda](https://wordpress.org/support/users/jcastaneda/),
 * We are always happy to assist! 🙂
 * Feel free in case of any questions in future.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Massive database value’ is closed to new replies.

 * ![](https://ps.w.org/popup-builder/assets/icon-128x128.gif?rev=2698840)
 * [Popup Builder - Create highly converting, mobile friendly marketing popups.](https://wordpress.org/plugins/popup-builder/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/popup-builder/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/popup-builder/)
 * [Active Topics](https://wordpress.org/support/plugin/popup-builder/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/popup-builder/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/popup-builder/reviews/)

## Tags

 * [db](https://wordpress.org/support/topic-tag/db/)
 * [performance](https://wordpress.org/support/topic-tag/performance/)
 * [query](https://wordpress.org/support/topic-tag/query/)

 * 5 replies
 * 2 participants
 * Last reply from: [Sygnoos Support](https://wordpress.org/support/users/sygnoossupport/)
 * Last activity: [6 years, 3 months ago](https://wordpress.org/support/topic/massive-database-value/#post-12327580)
 * Status: resolved