james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Danny Angus" <da...@apache.org>
Subject JDBC MAIL and SPOOL
Date Fri, 01 Nov 2002 11:44:06 GMT
Hi,

messing around with performance I think that mail tables should be indexed on repository_name,
as well as having (repository_name,message_name) as the PK.

anyone wanting to test this theory should run..

	mysql> alter table [TABLENAME] add key repo (repository_name);

against your existing tables.

the patch for sql resources is:



C:\d\cvsdir\jakarta-james\src\conf>cvs -z9 diff -u sqlResources.xml
Index: sqlResources.xml
===================================================================
RCS file: /home/cvs/jakarta-james/src/conf/sqlResources.xml,v
retrieving revision 1.14
diff -u -r1.14 sqlResources.xml
--- sqlResources.xml    26 Aug 2002 18:53:17 -0000      1.14
+++ sqlResources.xml    1 Nov 2002 11:34:05 -0000
@@ -133,7 +133,8 @@
             remote_addr varchar (20) NOT NULL ,
             message_body longblob NOT NULL ,
             last_updated datetime NOT NULL,
-            PRIMARY KEY (message_name, repository_name)
+            PRIMARY KEY (message_name, repository_name),
+            KEY repo (repository_name)
         )
     </sql>
     <sql name="createTable" db="hypersonic">


--
To unsubscribe, e-mail:   <mailto:james-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:james-dev-help@jakarta.apache.org>


Mime
View raw message