Title: Options table autoincrement grow
Last modified: August 21, 2016

---

# Options table autoincrement grow

 *  [igov](https://wordpress.org/support/users/igov/)
 * (@igov)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/options-table-autoincrement-grow/)
 * Hello,
 * If i check this option
 * > Give blocked users a second chance with a CAPTCHA Form:
 *  it adds several records in wp_options table per spammer request (comment or 
   login).
 * On our heavy traffic site this makes autoincrement value of wp_options primary
   index grow quite fast. I got a value of 988928 for 2 days.
 * I recommend in next versions of the plugin separate db table for saving captcha
   data OR saving in temp files and cron job for garbage collect.
 * [https://wordpress.org/plugins/stop-spammer-registrations-plugin/](https://wordpress.org/plugins/stop-spammer-registrations-plugin/)

Viewing 1 replies (of 1 total)

 *  Plugin Contributor [Keith P. Graham](https://wordpress.org/support/users/kpgraham/)
 * (@kpgraham)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/options-table-autoincrement-grow/#post-4996221)
 * I have used a couple of different strategies. WordPress’s transient data api 
   is terrible. What I really need is a cookie, but it cookies sometimes break WordPress
   and interfere with other plugins.
 * I probably will not be releasing a new version of the plugin, but if I do, I 
   intend to fix this, but I am not sure how, yet.
 * Keith

Viewing 1 replies (of 1 total)

The topic ‘Options table autoincrement grow’ is closed to new replies.

 * ![](https://ps.w.org/stop-spammer-registrations-plugin/assets/icon-256x256.png?
   rev=3377746)
 * [Stop Spammers Classic](https://wordpress.org/plugins/stop-spammer-registrations-plugin/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/stop-spammer-registrations-plugin/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/stop-spammer-registrations-plugin/)
 * [Active Topics](https://wordpress.org/support/plugin/stop-spammer-registrations-plugin/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/stop-spammer-registrations-plugin/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/stop-spammer-registrations-plugin/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Keith P. Graham](https://wordpress.org/support/users/kpgraham/)
 * Last activity: [12 years, 2 months ago](https://wordpress.org/support/topic/options-table-autoincrement-grow/#post-4996221)
 * Status: not resolved