The following issue has been CLOSED ====================================================================== http://dbmail.org/mantis/view.php?id=746 ====================================================================== Reported By: zmi Assigned To: paul ====================================================================== Project: DBMail Issue ID: 746 Category: Authentication layer Reproducibility: always Severity: minor Priority: normal Status: closed target: Resolution: open Fixed in Version: ====================================================================== Date Submitted: 14-Dec-08 18:08 CET Last Modified: 29-Jul-09 07:38 CEST ====================================================================== Summary: dbmail-util -p should let delete messages to the database Description: Currently, dbmail-util -p searches all messages and deletes them one-by-one. Function db_deleted_purge() can be reduced to snprintf(query, DEF_QUERYSIZE, "DELETE FROM %smessages WHERE status=%d",DBPFX, MESSAGE_STATUS_PURGE); plus some lines to report deleted messages.
The current implementation is very slow when a lot of messages were deleted, and puts a lot of additional load on the database. ====================================================================== ---------------------------------------------------------------------- (0002877) netvulture (developer) - 29-Jul-09 07:38 http://dbmail.org/mantis/view.php?id=746#c2877 ---------------------------------------------------------------------- This change has been implemented. Issue History Date Modified Username Field Change ====================================================================== 14-Dec-08 18:08 user470 New Issue 15-Dec-08 09:00 paul Reporter user470 => _morf_ 15-Dec-08 09:00 paul Severity tweak => minor 15-Dec-08 10:33 paul Reporter _morf_ => zmi 15-Dec-08 10:33 paul Assigned To => paul 15-Dec-08 10:33 paul Status new => assigned 29-Jul-09 07:38 netvulture Note Added: 0002877 29-Jul-09 07:38 netvulture Status assigned => closed ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
