About queries

[Robert9]

My forum_list has about 50 queries, a private done list of 100 resources has 11 queries.
My resources home has 156, a category with show 100 resources has 550 queries.
So it seems to me that there is a problem.

So i start searching ...

An addon that should add a link for putting resources to a wishllist adds one query per resource, so i have found 100 from the 550.
After watching the tables it seems that the data is fetched from a second table instead of calc values to a new field in xf_resource.

Finally i found the aggressor, it is a small addon that should add prev and next to resource_view; so it should not be there in the category_view at all.
Now i am glad to have found it and start watching the code.

Maybe there is nobody who wants to care for something like that, but i would like to have a field for all the resources here with a short info about the range of queries.

 

[Kirby]

Maybe there is nobody who wants to care for something like that, but i would like to have a field for all the resources here with a short info about the range of queries.

IMHO the sad truth is:

Many hobbist/semi-professional developers don't even know what kind if impact (queries, etc.) their Add-ons do have, so having that field probalby would not help that much.

 

[Paul B]

This is where a bit of due diligence is required.

If you're interested in a particular add-on, ask the author about query count and performance impact.

Install on a test installation first so both of those can be explicitly checked in your environment.

 

[DragonByte Tech]

i would like to have a field for all the resources here with a short info about the range of queries.

Unfortunately query count is not necessarily reflective of the scalability of the modification, not to mention it can be a bit of a pain to obtain an accurate query count for every action.

Of course, your specific example is an outlier, and developers should always think about the amount of queries they add to the system, so I'm not disagreeing with that part.