wp-options Overload

  • Resolved dzawacki

    (@dzawacki)


    9 years, 11 months ago

    I have been having performance issues with my website and through a series of tests, I’ve narrowed it down to the Participants Database plugin which is slowing the site down. There was a long wait to process calls to the database. Upon looking at the database, I noticed that the wp-options table had over 2000 entries. This is far more than I’d want. I looked at the entries and the vast majority of them seem to be related to the Participants Database plugin as many of the option_name field begins with “_wp_session_” or “_wp_session_expires_” and then the option_value contains “pdb”.

    I immediately disabled the PHP Sessions option in the plugin, hoping this will prevent more rows from being added to the table.

    My question is, though, how can I easily clean these options from the table? Will they clean themselves or is it manual? There’s currently 2331 entries that begin with _wp_session_ and I’d like to know what they’re for and how to easily clean them up.

    https://wordpress.org/plugins/participants-database/

Viewing 1 replies (of 1 total)
  • Plugin Author xnau webdesign

    (@xnau)

    9 years, 11 months ago

    Those entries in the options table are just like WP transients, it’s the same mechanism. They do tend to build up, but they are not autoloaded, and so are not a performance issue.

    You can remove them all if you like, all they do is make sure that when someone signs up, the application knows which record the user just created, so they see their thanks message and get their email.

    I suggest you install a plugin named “Query Monitor” that will give you a comprehensive picture of your WP performance.

    I have several database optimizations in store for the next release.

Viewing 1 replies (of 1 total)
  • The topic ‘wp-options Overload’ is closed to new replies.