From aaff4a78863c0103d5c6da86e324e81cc0c2a564 Mon Sep 17 00:00:00 2001 From: Bharat Mediratta Date: Thu, 14 May 2009 02:14:46 +0000 Subject: Introduce a relative_path_cache column in the items table. This lets us avoid doing lots of MPTT lookups to find the parent path when we're trying to generate thumbnails, etc. Invalidate the cache at all the right times. This greatly reduces our query count on album page views. This fixes ticket #40. --- core/helpers/core_installer.php | 1 + 1 file changed, 1 insertion(+) (limited to 'core/helpers') diff --git a/core/helpers/core_installer.php b/core/helpers/core_installer.php index 9f7c3f22..55306eaa 100644 --- a/core/helpers/core_installer.php +++ b/core/helpers/core_installer.php @@ -75,6 +75,7 @@ class core_installer { `view_count` int(9) default 0, `width` int(9) default NULL, `rand_key` float default NULL, + `relative_path_cache` varchar(255) default NULL, `sort_column` varchar(64) default NULL, `sort_order` char(4) default 'ASC', `weight` int(9) NOT NULL default 0, -- cgit v1.2.3