The following issue has been SUBMITTED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=1004 ====================================================================== Reported By: santa Assigned To: ====================================================================== Project: DBMail Issue ID: 1004 Category: Database layer Reproducibility: have not tried Severity: tweak Priority: normal Status: new target: ====================================================================== Date Submitted: 28-Feb-13 09:40 CET Last Modified: 28-Feb-13 09:40 CET ====================================================================== Summary: Migrate remaining plain text SQLs to prepared statements Description: dbmail have a number of SQLs, created like this:
r = db_query(c, "SELECT 0,COUNT(*) FROM %smessages WHERE mailbox_idnr=%llu ", ...); where the actual parameter is printf'd into the SQL string. This produces a number of similar requests with different WHERE condition and pollutes database query cache and leads to a performance penalty. Can this be improved with a prepared statements? ====================================================================== Issue History Date Modified Username Field Change ====================================================================== 28-Feb-13 09:40 santa New Issue ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
