We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 42543
    • 3 Posts
    Hi!

    I'm just optimizing modx site.

    Found 11 similar queries after every [[Wayfinder]] call on clean system.

    Query
    SELECT `modChunk`.`id` AS `modChunk_id`, `modChunk`.`source` AS `modChunk_source`, `modChunk`.`property_preprocess` AS `modChunk_property_preprocess`, `modChunk`.`name` AS `modChunk_name`, `modChunk`.`description` AS `modChunk_description`, `modChunk`.`editor_type` AS `modChunk_editor_type`, `modChunk`.`category` AS `modChunk_category`, `modChunk`.`cache_type` AS `modChunk_cache_type`, `modChunk`.`snippet` AS `modChunk_snippet`, `modChunk`.`locked` AS `modChunk_locked`, `modChunk`.`properties` AS `modChunk_properties`, `modChunk`.`static` AS `modChunk_static`, `modChunk`.`static_file` AS `modChunk_static_file` FROM `modx_site_htmlsnippets` AS `modChunk` WHERE `modChunk`.`name` = ''

    Result is empty.

    1) What is it? Is it normal?
    2) Every page load sends 300+ queries to database with empty cache... Is it normal?

    Revo 2.2.6

    Sorry for my english
    Thanx [ed. note: gigi.dp.ua last edited this post 13 years, 8 months ago.]
      • 28042 ☆ A M B ☆
      • 24,524 Posts
      No that is definitely not normal. Where is this query shown?
        Studying MODX in the desert - http://sottwell.com
        Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
        Join the Slack Community - http://modx.org
        • 42543
        • 3 Posts
        Quote from: sottwell at Jan 16, 2013, 04:28 AM
        No that is definitely not normal. Where is this query shown?

        In mysql general_log after empty cache and page generation

        USE mysql;
        SELECT count(*), argument
        FROM general_log
        WHERE argument LIKE 'SELECT%'
        GROUP BY argument;
        TRUNCATE TABLE general_log;