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))
CommentFileSizeAuthor
Screenshot_3.jpg494.47 KBgeorgekhair

Comments

georgekhair created an issue. See original summary.

joseph.olstad’s picture

see 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.inc

There is a function call to ctools_export_load_object called by file_displays_load

do 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

joseph.olstad’s picture

Status: Needs work » Postponed (maintainer needs more info)
joseph.olstad’s picture

Issue summary: View changes
joseph.olstad’s picture

Meanwhile, 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.

joseph.olstad’s picture

Status: Postponed (maintainer needs more info) » Active
georgekhair’s picture

I 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.

joseph.olstad’s picture

What 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.

georgekhair’s picture

I 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

joseph.olstad’s picture

joseph.olstad’s picture

Status: Active » Needs review

please review the related patch

joseph.olstad’s picture

joseph.olstad’s picture

grab 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.

joseph.olstad’s picture

Version: 7.x-2.20 » 7.x-2.21

Please 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

joseph.olstad’s picture

Category: Bug report » Support request
Status: Needs review » Fixed

Pretty sure this is resolved by either the latest release or the latest release PLUS the mentionned patch.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.