Multiple calls to wp_options

  • Resolved name

    (@technologypoet)


    7 years, 2 months ago

    Hey Robin,

    I was doing some performance tuning on a site, and New Relic flagged some calls from bbPress Style pack.
    Here’s an example:
    SELECT option_value FROM wp_options WHERE option_name = ‘bsp_roles’ LIMIT 1

    It looks like there are on the order of ~20 of these calls happening for each page that bbpress style pack is on for different options from wp_options. I wonder whether it’s possible to group these all into a single call, and whether that would be more efficient?

    FWIW the wp_options in question has ~2,500 rows and is ~300 KB in size

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Robin W

    (@robin-w)

    7 years, 2 months ago

    does new relic tell you what timing impact that has on your site?

    Plugin Author Robin W

    (@robin-w)

    7 years, 2 months ago

    my wp_options has 1300 entries, but the WHOLE back end process (everything the server neds to do before starting to send to the browser) takes 1/4 second.

    Thread Starter name

    (@technologypoet)

    7 years, 2 months ago

    The queries from bps alone were taking about 200ms-300ms combined on some pages (total for all backend was ~800ms, but slowed to ~2000ms on some pages – I’ve got a lot of plugins on the site)

    Plugin Author Robin W

    (@robin-w)

    7 years, 2 months ago

    ok, I have no current plans to change how that works, bbpress can be called within widgets on non bbppress pages, and I do not know what any particular site needs.

    Thread Starter name

    (@technologypoet)

    7 years, 2 months ago

    ok thanks

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

The topic ‘Multiple calls to wp_options’ is closed to new replies.