Defintely it makes sense and it works. I noticed the absence of a primary key before. Millions of records in a nonindexed table? Hummm...It doesn’t feel right. Thanks for the quick response. I suggest adding this PK on new dbmail releases. It will boost performance in heavy loaded servers. Sincerely. Rogerio >Hi, > >The following update should add the missing primary key so you get sub second >response times. >ALTER TABLE dbmail_authlog > ADD PRIMARY KEY (id); > >Kind regards, >Alan
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
