Markus Kroetzsch has uploaded a new change for review. 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. 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, 118 insertions(+), 25 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/SemanticMediaWiki refs/changes/48/28948/1 -- To view, visit https://gerrit.wikimedia.org/r/28948 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I92c6ecf00811db52f920c73904402da7cc1cdaad Gerrit-PatchSet: 1 Gerrit-Project: mediawiki/extensions/SemanticMediaWiki Gerrit-Branch: master Gerrit-Owner: Markus Kroetzsch <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
