The following issue has been SUBMITTED. 
====================================================================== 
http://www.dbmail.org/mantis/view.php?id=746 
====================================================================== 
Reported By:                zmi3
Assigned To:                
====================================================================== 
Project:                    DBMail
Issue ID:                   746
Category:                   Authentication layer
Reproducibility:            always
Severity:                   tweak
Priority:                   normal
Status:                     new
target:                      
====================================================================== 
Date Submitted:             14-Dec-08 18:08 CET
Last Modified:              14-Dec-08 18:08 CET
====================================================================== 
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.
====================================================================== 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
14-Dec-08 18:08 zmi3           New Issue                                    
======================================================================

_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev

Reply via email to