[Wikidata-bugs] [Maniphest] [Commented On] T176844: Look into truthy nt dump performance

[hoo]

hoo added a comment.

With PHP 5.5.9-1ubuntu4.22 on snapshot1005:

6 alternating runs with --sharding-factor 5 --shard 0 --limit 2000 (ttl vs. nt):
(62.110+65.767+63.446+63.018+66.504+64.367)/(43.654+44.974+47.964+44.570+47.304+48.088) = 1.393

Optimized nt vs. ttl:
(56.080+60.318+58.797+55.146+60.437+65.327)/(40.603+42.479+39.114+41.382+42.134+40.952) = 1.444

Ratio non-optimized/ optimized version:
(62.110+65.767+63.446+63.018+66.504+64.367)/(56.080+60.318+58.797+55.146+60.437+65.327) = 1.082

Ratio first/ second ttl run (in a perfect world this would be 1):
(43.654+44.974+47.964+44.570+47.304+48.088)/(40.603+42.479+39.114+41.382+42.134+40.952) = 1.121

Given the huge error in the last number, these results are probably mostly foobar.

TASK DETAIL

https://phabricator.wikimedia.org/T176844

EMAIL PREFERENCES

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

To: hoo
Cc: thiemowmde, Stashbot, gerritbot, Aklapper, daniel, Lydia_Pintscher, aude, hoo, ArielGlenn, GoranSMilovanovic, QZanden, Izno, Wikidata-bugs, Svick, Mbch331, jeremyb

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs