I enable dev module to track the performance of my site, i found that there is 3 queries slowing down my site.
Please help with this
ms#whereops
query
target
303.022ctools_export_load_object (link is external)P A E
SELECT t__0.* FROM file_display t__0 WHERE (name IN (:db_condition_placeholder_0, :db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_placeholder_4, :db_condition_placeholder_5, :db_condition_placeholder_6, :db_condition_placeholder_7, :db_condition_placeholder_8, :db_condition_placeholder_9, :db_condition_placeholder_10, :db_condition_placeholder_11, :db_condition_placeholder_12, :db_condition_placeholder_13, :db_condition_placeholder_14, :db_condition_placeholder_15, :db_condition_placeholder_16, :db_condition_placeholder_17, :db_condition_placeholder_18, :db_condition_placeholder_19, :db_condition_placeholder_20, :db_condition_placeholder_21, :db_condition_placeholder_22, :db_condition_placeholder_23, :db_condition_placeholder_24, :db_condition_placeholder_25, :db_condition_placeholder_26, :db_condition_placeholder_27, :db_condition_placeholder_28, :db_condition_placeholder_29, :db_condition_placeholder_30, :db_condition_placeholder_31, :db_condition_placeholder_32, :db_condition_placeholder_33, :db_condition_placeholder_34, :db_condition_placeholder_35, :db_condition_placeholder_36, :db_condition_placeholder_37, :db_condition_placeholder_38, :db_condition_placeholder_39, :db_condition_placeholder_40, :db_condition_placeholder_41, :db_condition_placeholder_42, :db_condition_placeholder_43, :db_condition_placeholder_44, :db_condition_placeholder_45, :db_condition_placeholder_46, :db_condition_placeholder_47, :db_condition_placeholder_48, :db_condition_placeholder_49, :db_condition_placeholder_50, :db_condition_placeholder_51, :db_condition_placeholder_52, :db_condition_placeholder_53, :db_condition_placeholder_54, :db_condition_placeholder_55, :db_condition_placeholder_56, :db_condition_placeholder_57, :db_condition_placeholder_58, :db_condition_placeholder_59, :db_condition_placeholder_60, :db_condition_placeholder_61, :db_condition_placeholder_62, :db_condition_placeholder_63, :db_condition_placeholder_64, :db_condition_placeholder_65, :db_condition_placeholder_66, :db_condition_placeholder_67, :db_condition_placeholder_68, :db_condition_placeholder_69, :db_condition_placeholder_70, :db_condition_placeholder_71, :db_condition_placeholder_72, :db_condition_placeholder_73, :db_condition_placeholder_74, :db_condition_placeholder_75, :db_condition_placeholder_76, :db_condition_placeholder_77, :db_condition_placeholder_78, :db_condition_placeholder_79, :db_condition_placeholder_80, :db_condition_placeholder_81, :db_condition_placeholder_82, :db_condition_placeholder_83, :db_condition_placeholder_84, :db_condition_placeholder_85, :db_condition_placeholder_86, :db_condition_placeholder_87, :db_condition_placeholder_88, :db_condition_placeholder_89, :db_condition_placeholder_90, :db_condition_placeholder_91, :db_condition_placeholder_92, :db_condition_placeholder_93, :db_condition_placeholder_94, :db_condition_placeholder_95, :db_condition_placeholder_96, :db_condition_placeholder_97, :db_condition_placeholder_98, :db_condition_placeholder_99, :db_condition_placeholder_100, :db_condition_placeholder_101, :db_condition_placeholder_102, :db_condition_placeholder_103, :db_condition_placeholder_104, :db_condition_placeholder_105, :db_condition_placeholder_106, :db_condition_placeholder_107, :db_condition_placeholder_108, :db_condition_placeholder_109, :db_condition_placeholder_110, :db_condition_placeholder_111, :db_condition_placeholder_112, :db_condition_placeholder_113, :db_condition_placeholder_114, :db_condition_placeholder_115, :db_condition_placeholder_116, :db_condition_placeholder_117, :db_condition_placeholder_118, :db_condition_placeholder_119, :db_condition_placeholder_120, :db_condition_placeholder_121, :db_condition_placeholder_122, :db_condition_placeholder_123, :db_condition_placeholder_124, :db_condition_placeholder_125, :db_condition_placeholder_126, :db_condition_placeholder_127, :db_condition_placeholder_128, :db_condition_placeholder_129, :db_condition_placeholder_130, :db_condition_placeholder_131, :db_condition_placeholder_132, :db_condition_placeholder_133,
.......
snipped, CONTINUES SAME PATTERN THROUGH 5289
end of snip snip....
.......
:db_condition_placeholder_5286, :db_condition_placeholder_5287, :db_condition_placeholder_5288, :db_condition_placeholder_5289, :db_condition_placeholder_5290, :db_condition_placeholder_5291, :db_condition_placeholder_5292, :db_condition_placeholder_5293, :db_condition_placeholder_5294, :db_condition_placeholder_5295, :db_condition_placeholder_5296, :db_condition_placeholder_5297, :db_condition_placeholder_5298, :db_condition_placeholder_5299, :db_condition_placeholder_5300, :db_condition_placeholder_5301, :db_condition_placeholder_5302, :db_condition_placeholder_5303, :db_condition_placeholder_5304, :db_condition_placeholder_5305, :db_condition_placeholder_5306, :db_condition_placeholder_5307, :db_condition_placeholder_5308, :db_condition_placeholder_5309, :db_condition_placeholder_5310, :db_condition_placeholder_5311, :db_condition_placeholder_5312, :db_condition_placeholder_5313, :db_condition_placeholder_5314, :db_condition_placeholder_5315, :db_condition_placeholder_5316, :db_condition_placeholder_5317, :db_condition_placeholder_5318, :db_condition_placeholder_5319, :db_condition_placeholder_5320, :db_condition_placeholder_5321, :db_condition_placeholder_5322, :db_condition_placeholder_5323))
Comments
Comment #2
joseph.olstadsee the related issue, try out one of the patches by Damien Mckenna
unfortunately it might cause other issues.
but curious if the related issue patch will change the devel query stats.
Check the code in
file_entity.file_api.incThere is a function call to
ctools_export_load_objectcalled byfile_displays_loaddo you have a view on your homepage of file entities?
how is this view configured?
what version of views are you using?
what version of ctools are you using?
could possibly be exacerbated by the configuration of your view that is using the file_entity
various things to ponder
Comment #3
joseph.olstadComment #4
joseph.olstadComment #5
joseph.olstadMeanwhile, I might suggest you look into the boost module for caching, you could enable boost caching for your home page.
its the simplest caching solution, but ya to perfect its configuration in all circumstances requires skill.
Comment #6
joseph.olstadComment #7
georgekhair commentedI applied the batch #2642764: Speed up via shortcutting token file_entity_file_load, but it breaks the website, it always giving me error.
I checked the code in file_entity.file_api.inc and removed the code in the function file_displays_load, it become faster, but i dont know if this change will effect the work of other functions?
I am using views 7.x-3.20 and ctools 7.x-1.14
I already have cache enabled, i am using wincache and boost enabled.
Comment #8
joseph.olstadWhat about your view? how many results in it? how many file entities? what is the view configuration?
also, maybe some other modules comming into play here, could get hints by your view configuration.
Comment #9
georgekhair commentedI have a view which is Dynamic display Block that gets the last 5 articles from a specific content type and display it in slider, the slider using Cycleblock .
It has styles for the images (responsive styles)
The second view is getting 4 nodes from another type of articles and display thumbs and text
Comment #10
joseph.olstadI've rerolled a patch for the related performance issue, can you please try it ?
https://www.drupal.org/files/issues/2018-04-28/file_entity-n2642764-34.p...
#2642764-34: Speed up via shortcutting token file_entity_file_load
Comment #11
joseph.olstadplease review the related patch
Comment #12
joseph.olstadan additional performance patch to review is here:
#2966026: Performance fix - rename file_entitycache_file_load to file_entity_entitycache_file_load
Comment #13
joseph.olstadgrab the latest dev 7.x-2.x dev release (it includes #2966026: Performance fix - rename file_entitycache_file_load to file_entity_entitycache_file_load)
and then apply #2642764-34: Speed up via shortcutting token file_entity_file_load
try this, please let us know if this improves the performance.
Comment #14
joseph.olstadPlease apply and review this patch using the latest release 7.x-2.21 (released a few minutes ago)
#2642764-34: Speed up via shortcutting token file_entity_file_load
Comment #15
joseph.olstadPretty sure this is resolved by either the latest release or the latest release PLUS the mentionned patch.