Ultimate CMS too many queries

  • Hi,
    recently I have experienced troubles with a website, which database has been suspended several times a day from when I activated Ultimate CMS, because of too many database queries, more than 50.000 in less than an hour, for a website with around 400 unique visitors per day.

    Checking at the weight of every single plugin, widget, loop and so, I realized that Ultimate CMS takes around 26 database queries every time the home page is opened. The strangest is that in the home page the taxonomy isn’t called at all, excepted for a tag cloud, which runs just one query.

    The website is https://www.ossigenoinformazione.it . Now you can see a query counter at the bottom right of every page.

    How is that possible that this plugin runs so many queries without even be needed in the home page?

    https://www.ads-software.com/extend/plugins/ultimate-cms/

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

  • Does this behavior go away if you deactivate the plugin?

    Thread Starter lorenzodp

    (@lorenzodp)

    Yes, absolutely. Deactivating the plugin and reloading the page I get 26 queries less.
    The loop i preceded by:
    query_posts($query_string . ‘&cat=-1990,-2684,-91’);
    which acts on categories. The taxonomy is just used for the cloud.

    Plugin Author XYDAC

    (@deepakseth)

    I am checking this up and will update over it soon.
    -Xydac

    Thread Starter lorenzodp

    (@lorenzodp)

    Hi Xydac and thanks for your support.

    I also want to aware you that the Pagespeed service of Google for developers:
    (https://developers.google.com/speed/pagespeed/insights?utm_source=analytics#url=http_3A_2F_2Fwww.ossigenoinformazione.it_2F&mobile=false&rule=ServerResponseTime)
    during a general check of the web server speed, noticed that the file /plugins/ultimate-cms/script.php takes 1,4 seconds to load. Maybe this can be a useful information to you.

    Plugin Author XYDAC

    (@deepakseth)

    Basically this script.php is a combined collection of all the javascript required by your site due to Ultimate CMS plugin.
    The values in this file are generated at runtime based on what field types or post types or taxonomies etc are activated on your site

    Along with that a few extra javascript is also loaded which is required by the plugin UI.

    I suppose that is completely normal behavior.

    Regards,
    -Xydac

    Normal?

    Normal for what?

    That number of queries is NOT normal for a CMS, including WP.

    Did you consider the number of queries when you designed this plugin?

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Ultimate CMS too many queries’ is closed to new replies.