Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Jacob N. Breetvelt

    (@opajaap)

    The list of metatags of featured photos takes only one db query, see the function wppa_add_metatags() in wppa-non-admin.php

    If you nevertheless want to get rid of this list, untick Table IX-C1 and C2.

    If you want to know how many db queries wppa+ generates, do the following:

    Tick IX-A3: Allow wppa+ debugging.

    Go to a page you want to investigate, add &debug ( or ?debug on a clean url ) on the addressline and press enter.

    A lot of debug info is added to the page, look for info like:

    [WPPA+ dbg msg: Cumulative query statistics: Q=query, G=cache
    Q11b=>1, Q201=>1, Q225=>1, Q27=>1, Q59=>1, Q90=>1,
    G90=>47, G91=>201,
    Total queries attempted: 254, Cash hits: 248, equals 97.64%]

    In this example it means that wppa+ needed 254 times data from the db of wich 248 times the data was already present in the wppa+ internal cache, so there were only 6 actual db queries.

    Thread Starter Debra

    (@notebookingpages)

    Thanks for the quick feedback!

    Without changing any settings-
    Results on 3 different pages tested:
    Total queries attempted: 124, Cash hits: 62, equals 50.00%
    So, that means there were 62 actual db queries, correct?

    Unticked the Table IX-C1 and C2 –
    New results on same three pages:
    Shows no results for queries.
    So I guess that solves that!

    Thanks for the awesome support! ??

    Plugin Author Jacob N. Breetvelt

    (@opajaap)

    Thanx for this. It brings me on an idea to further improve the internal caching mechanism, i.e. reduce queries further.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘About 70 WPPA database queries per page on my site’ is closed to new replies.