Jeroen De Dauw has submitted this change and it was merged. Change subject: Caching mechanism for property table hashes ......................................................................
Caching mechanism for property table hashes Property hashes are optionally read and cached when reading the smw_ids table anyway, but only if requested by the caller. The cache is kept very small (1) and is supposed to be used in another call of getPropertyTableHashes() that most likely follows very soon after. This reduces the number of SELECT for getting property hashes significantly, since they can usually be combined with another SELECT immediately before them. In local tests, the number of reads to smw_ids went down by about 40% when refreshing the data. Update: Modified protected helper method name for consistent naming. Change-Id: I92c6ecf00811db52f920c73904402da7cc1cdaad --- M includes/storage/SQLStore/SMW_SQLStore3_Readers.php M includes/storage/SQLStore/SMW_SQLStore3_Writers.php M includes/storage/SQLStore/SMW_Sql3SmwIds.php 3 files changed, 123 insertions(+), 25 deletions(-) Approvals: Jeroen De Dauw: Verified; Looks good to me, approved -- To view, visit https://gerrit.wikimedia.org/r/28948 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: I92c6ecf00811db52f920c73904402da7cc1cdaad Gerrit-PatchSet: 2 Gerrit-Project: mediawiki/extensions/SemanticMediaWiki Gerrit-Branch: master Gerrit-Owner: Markus Kroetzsch <[email protected]> Gerrit-Reviewer: Jeroen De Dauw <[email protected]> Gerrit-Reviewer: Markus Kroetzsch <[email protected]> Gerrit-Reviewer: Nischayn22 <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
