Options table autoincrement grow

  • igov

    (@igov)


    9 years, 10 months ago

    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/

Viewing 1 replies (of 1 total)
  • Keith P. Graham

    (@kpgraham)

    9 years, 10 months ago

    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.