You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-dev@james.apache.org by Danny Angus <da...@apache.org> on 2002/11/01 12:44:06 UTC
JDBC MAIL and SPOOL
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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: JDBC MAIL and SPOOL
Posted by "Noel J. Bergman" <no...@devtech.com>.
I'll do some testing, but since the listmessages query is keyed solely by
repository_name, I'd +1.
--- Noel
-----Original Message-----
From: Danny Angus [mailto:danny@apache.org]
Sent: Friday, November 01, 2002 6:44
To: James Developers List
Subject: JDBC MAIL and SPOOL
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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>