The following issue has been ASSIGNED. 
====================================================================== 
http://www.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:                     assigned
target:                      
====================================================================== 
Date Submitted:             14-Dec-08 18:08 CET
Last Modified:              15-Dec-08 10:33 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 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     
======================================================================

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

Reply via email to