From d0d261bec97595492a4d1da44121c6fb919ea2ed Mon Sep 17 00:00:00 2001
From: "godzilla80@gmx.net" <>
Date: Sat, 9 May 2009 12:56:23 +0000
Subject: Fixed Issue #141 - TDbCache performance: modify structure of indices,
 new property 'FlushInterval' to control how often expired items will be
 removed

---
 UPGRADE | 11 ++++++++++-
 1 file changed, 10 insertions(+), 1 deletion(-)

(limited to 'UPGRADE')

diff --git a/UPGRADE b/UPGRADE
index baec1403..3dbd63e2 100644
--- a/UPGRADE
+++ b/UPGRADE
@@ -1,5 +1,5 @@
 
-         Upgrading Instructions for PRADO Framework v3.1.4
+         Upgrading Instructions for PRADO Framework v3.1.5
          =================================================
 
 !!!IMPORTANT!!!
@@ -9,6 +9,15 @@ if you want to upgrade from version A to version C and there is
 version B between A and C, you need to following the instructions
 for both A and B.
 
+Upgrading from v3.1.4
+---------------------
+- The structure of indices used by TDbCache has been changed by replacing
+  PRIMARY KEY on 'itemkey' with non-unique index and adding an additional index on column 'expire'.
+  Existing tables should be amended or deleted and recreated as follows: 
+  CREATE TABLE pradocache (itemkey CHAR(128), value BLOB, expire INT)
+  CREATE INDEX IX_itemkey ON pradocache (itemkey)
+  CREATE INDEX IX_expire ON pradocache (expire)
+
 Upgrading from v3.1.3
 ---------------------
 - The prado-cli and prado-cli.bat scripts have been moved into
-- 
cgit v1.2.3