Index: trunk/admin/install/inportal_schema.sql
===================================================================
diff -u -r1176 -r1267
--- trunk/admin/install/inportal_schema.sql	(.../inportal_schema.sql)	(revision 1176)
+++ trunk/admin/install/inportal_schema.sql	(.../inportal_schema.sql)	(revision 1267)
@@ -563,7 +563,8 @@
   Context varchar(255) default NULL,
   GroupList varchar(255) NOT NULL default '',
   PRIMARY KEY  (SysCacheId),
-  KEY Name (Name)
+  KEY Name (Name),
+  KEY Expire (Expire)
 )    
 
 # --------------------------------------------------------
Index: trunk/admin/install/upgrades/inportal_upgrade_v1.0.10.sql
===================================================================
diff -u -r1197 -r1267
--- trunk/admin/install/upgrades/inportal_upgrade_v1.0.10.sql	(.../inportal_upgrade_v1.0.10.sql)	(revision 1197)
+++ trunk/admin/install/upgrades/inportal_upgrade_v1.0.10.sql	(.../inportal_upgrade_v1.0.10.sql)	(revision 1267)
@@ -12,6 +12,8 @@
 
 ALTER TABLE PortalUser ADD PassResetTime BIGINT(20);
 
+ALTER TABLE SysCache ADD INDEX (Expire);
+
 INSERT INTO Events VALUES (67, 'USER.PSWDC', '1', '0', 'In-Portal:Users', 'la_event_user.pswd_confirm', '0');
 INSERT INTO Events VALUES (68, 'USER.ADD.PENDING', 2, 0, 'In-Portal:Users', 'la_event_user.add.pending', 1)