Not Solved a lot of SQL Queries
#7
Not Solved
(2017-08-09, 02:18 PM)metulburr Wrote:
(2017-08-09, 02:08 PM)Devilshakerz Wrote: Templates Requiring Additional Calls showed the names of 16 templates that were not cached by their plugins, contributing to the number of queries.

There was a large amount of queries fetching user data, likely caused by Tagging Plugin! (you can verify that by viewing a post with a large number of mentioned users) - see if alternatives like DVZ Mentions, MentionMe fit your needs.

I dont think i have seen someone in a long time use tagging. Does the tag have to be in the thread loaded to activate that template? All the threads i have checked no one has tags users. I disabled hte tagging plugin and tried again, but this time i got 116 queries. Seemed like the same number of mybb_users calls as before. 
You can try deactivating other plugins in the same way.

Quote:does the additional calls mean there is nothing to do due to the plugin not caching them then?
These plugins would have to be modified for optimal performance (hook into global_start and add the template names that will be used to the global $templatelist variable - the core will preload them in a single query).
devilshakerz.com/pgp (DF3A 34D9 A627 42E5 BC6A 6750 1F2F B8AA 28FF E1BC) ▪ keybase.io/devilshakerz
Reply


Messages In This Thread
a lot of SQL Queries - by metulburr - 2017-08-08, 09:29 PM
RE: a lot of SQL Queries - by fizz - 2017-08-08, 11:44 PM
RE: a lot of SQL Queries - by frostschutz - 2017-08-09, 11:32 AM
RE: a lot of SQL Queries - by metulburr - 2017-08-09, 01:50 PM
RE: a lot of SQL Queries - by Devilshakerz - 2017-08-09, 02:08 PM
RE: a lot of SQL Queries - by metulburr - 2017-08-09, 02:18 PM
RE: a lot of SQL Queries - by Devilshakerz - 2017-08-09, 07:48 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)