Re: dbmail_authlog performance

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
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail