summaryrefslogtreecommitdiff
path: root/UPGRADE
diff options
context:
space:
mode:
authorgodzilla80@gmx.net <>2009-05-09 12:56:23 +0000
committergodzilla80@gmx.net <>2009-05-09 12:56:23 +0000
commitd0d261bec97595492a4d1da44121c6fb919ea2ed (patch)
treee52b5a7f9ee974a241164c1e994a0ef46c5e0bab /UPGRADE
parent93ffd43c381e96cdf4af245abcec52b75fe00fee (diff)
Fixed Issue #141 - TDbCache performance: modify structure of indices, new property 'FlushInterval' to control how often expired items will be removed
Diffstat (limited to 'UPGRADE')
-rw-r--r--UPGRADE11
1 files changed, 10 insertions, 1 deletions
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