Hi, > activated several caching possibilities. $wgMainCacheType is still set to > "CACHE_NONE" , but I use Concept Cache of SMW, Elasticserach and OPcache.
Which means you don't use the `ParserCache` which isn't recommended. I only recently added some comments on the "why caching matters" issue [0]. > But I wonder: Approximatly every 24 hours the wiki pages load very very > slow. But when I visit the site again, table and map is loaded very fast. Anecdotal evidence such as "pages load very very slow" doesn't allow any analysis (slow compared to what, what is defined as slow etc.) and I just looked at the mentioned page and it was fairly responsive (the page showed up within ~1-2 sec of the request) even though it contains a table with 9721 rows. > - which is the order/priority of different caching possibilities. I'm not sure how to answer this question because different types of cache are used depending on the context of a request so I'm not sure what you are referring to as "priority". > - should I set $smwgQConceptCacheLifetime higher for avoiding the loading > delay every 24 hours? Concept storage do work a bit different in `ElasticStore` where the results are kept in a separate `lookup` index. `$smwgQConceptCacheLifetime` is only used in connection with `SQLStore` side. When I first created the `ElasticStore` there weren't support for concepts or subqueries and only the possibility to use the `TermsLookup` [1] made it possible to combine and run queries that are either chained or require pre-computed input (as in case of the concept). There are some settings in regards to concepts in `ElasticStore` where there is a special cache to keep the lookup index key for an one hour by default to avoid having the re-create the concept lookup index on every request. Also, subqueries and concepts have a cap size of 10.000 by default to avoid users to create queries that are uncontrolled (aka. unlimited, select all entities of namespace X etc.). [0] https://github.com/SemanticMediaWiki/SemanticMediaWiki/issues/4245 [1] https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-terms-query.html Cheers On 8/22/19, Dan Mar <220...@gmail.com> wrote: > Dear list, > > I run a server: > MediaWiki 1.31.2 > PHP 7.2.5 (apache2handler) > MariaDB 10.2.25-MariaDB > ICU 60.2 > Elasticsearch 6.8.0 > > In the wiki there is a list of geodata (~9800 wiki pages) which are > displayed as table [0] and map [1]. Because the list is quite large I > activated several caching possibilities. $wgMainCacheType is still set to > "CACHE_NONE" , but I use Concept Cache of SMW, Elasticserach and OPcache. > The wiki itself is not updated quite often and more or less untouched for > days, even weeks > > But I wonder: Approximatly every 24 hours the wiki pages load very very > slow. But when I visit the site again, table and map is loaded very fast. > So some caching mechanism take effect but I'm unsure which one. So my > questions are: > > - when I use concept cache are queries still addressed to the elastic > store? > - which is the order/priority of different caching possibilities. > - should I set $smwgQConceptCacheLifetime higher for avoiding the loading > delay every 24 hours? > > Thanks for tips, Martin > > > [0] https://vb2.uni-wuerzburg.de/smw/topographia/index.php/Ortsliste > [1] https://vb2.uni-wuerzburg.de/smw/topographia/index.php/Ortskarte > _______________________________________________ Semediawiki-devel mailing list Semediawiki-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
