Changeset

9892:4803a25c7e36

mod_storage_sql: Cache total count if it's calculated as part of the current query
author Kim Alvefur <zash@zash.se>
date Fri, 22 Mar 2019 02:13:27 +0100
parents 9891:147b28d001a0
children 9893:15270547c91c
files plugins/mod_storage_sql.lua
diffstat 1 files changed, 3 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/plugins/mod_storage_sql.lua	Fri Mar 22 02:12:02 2019 +0100
+++ b/plugins/mod_storage_sql.lua	Fri Mar 22 02:13:27 2019 +0100
@@ -384,6 +384,9 @@
 					total = row[1];
 				end
 			end
+			if query.start == nil and query.with == nil and query["end"] == nil and query.key == nil then
+				archive_item_count_cache:set(cache_key, total);
+			end
 			if query.limit == 0 then -- Skip the real query
 				return noop, total;
 			end