num sql queries in page load

[icedogas]

Hello, thx for processwire and answer my question -

In wordpress was code

<?php
    echo '<center>'.get_num_queries().' queries ';
    timer_stop(1);
    echo ' second</center>';
?>

Wordpress shows how many sql queries makes engine(include cache or without cache) -

processwire have solution(code) like this?

[kongondo]

Hi Icedogas,

Welcome to PW and the forums.

If you switched debug on in your /site/config.php/, you would see the queries. Please note debug should only be turned on in dev/testing installs and not on your live/production server. 

Find this line in /site/config.php

$config->debug = false;  

and change it to 

$config->debug = true;  

Now in the Admin, you will see your queries (scroll down to the bottom). Note, this is only for the Admin. For frontend, you will have to do it differently using PHP code...

[Soma]

You maybe wan't to look into the debug.inc that comes with the admin theme

/wire/templates-admin/debug.inc

and counting queries is kinda pointless, the type of queries are important.

[Pete]

I think Soma makes a good point with his last sentence - many well-crafted queries can work far quicker than one cumbersome query.

Plus the technology has moved on so much in recent years that your server shouldn't really strain under lots of queries.

Also, there are many caching options for ProcessWire to cut some of those out (MarkupCache for select lists etc, ProCache to serve a static version of your site and other solutions as well).