diff options
| author | Bharat Mediratta <bharat@menalto.com> | 2009-05-14 02:14:46 +0000 |
|---|---|---|
| committer | Bharat Mediratta <bharat@menalto.com> | 2009-05-14 02:14:46 +0000 |
| commit | aaff4a78863c0103d5c6da86e324e81cc0c2a564 (patch) | |
| tree | 6b954f38d81b6e55bef265e09cca6b389db5e529 /core/helpers | |
| parent | e543b055fbcfeca7f25f6c31696d420b035574df (diff) | |
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.
Diffstat (limited to 'core/helpers')
| -rw-r--r-- | core/helpers/core_installer.php | 1 |
1 files changed, 1 insertions, 0 deletions
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, |