TSP Posted November 11, 2015 Share Posted November 11, 2015 (edited) In IPS 3.4 you had a solution that would save the topic views to a separate table. Every 3 hours it would then run a task that would update the views-column for the topics-table from the data gathered in this separate table. In IPS 4 you dropped this optional method and went with LOW_PRIORITY updates, which solves a problem where lots of queries to update the views-column in the topics-table could frequently lock the topics-table. However, this is still far from ideal for big communities with a lot of topics and visitors present. As it means that the query cache, for queries involving the topics-table, is very unlikely to come into play. As a consequence this can play a significant difference in the average server response time for the community, as it's "never" able to utilize the query cache for "topic list" queries. I would like you to reconsider this approach and let us be able to get such an option back again. Edited November 11, 2015 by TSP Kirill N 1 Link to comment Share on other sites More sharing options...
Kirill N Posted November 11, 2015 Share Posted November 11, 2015 Thanks for noticing this! Link to comment Share on other sites More sharing options...
Management Charles Posted November 11, 2015 Management Share Posted November 11, 2015 This will be resolved in 4.1.5. chilihead, Kirill N and TSP 3 Link to comment Share on other sites More sharing options...
Recommended Posts