WordPress.org

Ready to get started?Download WordPress

Forums

NextGEN Facebook: Advanced Optimization for All Social Websites
[resolved] Number of rows for ngfb in wp_options (4 posts)

  1. anordby76
    Member
    Posted 5 months ago #

    WTF is up with this:

    mysql> select distinct(substr(option_name, 1, 15)) as option_name_sub, count(*) as count from wp_options group by option_name_sub order by count desc limit 2;
    +-----------------+-------+
    | option_name_sub | count |
    +-----------------+-------+
    | _transient_time | 28609 |
    | _transient_ngfb | 28587 |
    +-----------------+-------+
    2 rows in set (0.15 sec)

    The _transient_time values is really _transient_timeout_ngfb_eaaa65bedba0432fc3f9d8bb50639262 but different opiton_name. Why so many wp_options rows for NGFB?!

    https://wordpress.org/plugins/nextgen-facebook/

  2. JS Morisset
    Member
    Plugin Author

    Posted 5 months ago #

    It looks like you have a large number of posts and pages. Why aren't you running an object cache like APC, Xcache, Memcache, etc.? Using your database for the transient cache is not optimal.

    You can turn off transient object caching completely with the NGFB_TRANSIENT_CACHE_DISABLE constant (see http://surniaulula.com/codex/plugins/nextgen-facebook/notes/constants/). You may see a slight decline in performance though.

    js.

  3. anordby76
    Member
    Posted 5 months ago #

    Not using an object cache because we have a shared web hotel where there is no such possibility. But we are about to move to our own server these days where I can look into that.

  4. JS Morisset
    Member
    Plugin Author

    Posted 5 months ago #

    If you're on a single server, APC is a good choice -- it's faster than TCP based caches, and does opcode + object caching.

    BTW, this page has a few good suggestions and pointers to improve performance: http://surniaulula.com/codex/plugins/nextgen-facebook/notes/performance-tuning/ (see the Optimize WordPress section).

    js.

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.