Addshore added a subscriber: Ladsgroup.
Addshore added a comment.

  One thing to note in the profiling is that a significant portion of the time 
that the query is executing is spent in a section of code in 
ApiResult::addValue, specifically the validateValue and size methods.
  I don't think we really need to do this, but we should consult with the core 
platform team and potentially remove this from the execution path for our apis?
  
  An equal amount of time seems to be spent in 
Wikibase\Lib\Serialization\SerializationModifier::modifyUsingCallback which 
could likely do with some optimizations.
  
  Noticeably in this call property id creation seems to take quite some time, 
it looks like the bulk of this overhead is due to joining and splitting around 
id prefixes, which we do not actually use.
  @Ladsgroup recently filed a ticket about the performance of EntityId and 
ItemId etc.
  I think we could make an improvement here probably by not doing so much logic 
in the constructor when we don't need to.
  Perhap we can also just remove all of this id prefix stuff for now as we 
don't use it.
  
  It'll be good to try and get a full profile of a completed execution.
  To do that we will have to see if we can temporarily remove the timeline 
restriction on one of the mwdebug servers.

TASK DETAIL
  https://phabricator.wikimedia.org/T249587

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Addshore
Cc: Ladsgroup, Lea_Lacroix_WMDE, Addshore, Ixocactus, Tarrow, Magnus, Aklapper, 
darthmon_wmde, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, 
_jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, 
Mbch331
_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

Reply via email to