DB connection question (programatically speaking)

[kofoid]

Howdy.... I am trying to reduce the number of DB connections my board makes.... how do I know when something is calling the database? Is it in the template or the PHP file? Is there a quick and dirty way to identify a proframmed DB "call"?

Do phrases typically call the DB? What about plugins?

[Sean S]

As for your question, most/all calls are within the php files. As for a quick or dirty way, I think the best way would be to turn off your forums and turn on the debug mode.

Phrases are stored in the database so yes.

[Princeton]

Although this is in the PROGRAMMING DISCUSSION forum, I'm guessing this is a vbulletin specific. So...

As an admin, you can Turn on DEBUG MODE.
https://vborg.vbsupport.ru/showthread.php?t=82835

When in DEBUG MODE, you will be able to see total queries, cached templates, templates used, page generation time, etc.


All templates and phrases are queried/cached (1 query) per page visit.
If you have an uncached template you will need to add it to the $globaltemplates array.

All plugins/products information are queried/cached at the start.
Individual plugins can create additional queries ... you will have to review each product/plugin you install.

[kofoid]

Sorry to post my question in the PROGRAMMING DISCUSSION forum, but I am going to have to look in my php files which is why I posted it HERE

[AN-net]

reducing your number of queries is also very easy by turning certain features via the admin panel. vbulletin denotes which features slow down performance or add queries. turning those features will increase performance and decrease the number of queries. there are also several modifications that will display load times and query loads without turning on debug.