Search and Reports page display speed up

[pdwalker]

I noticed that mailwatch has added an interesting feature. Under the "Search and Reports" it now displays a section called "Statistics" with oldest, newest and a message count of the currently applied filter (if applied) or all the messages (if no filter).

As interesting as it is, my database is slow, so loading this page adds a few of seconds to the load time, so I've removed it.

To do so, I've edited /var/www/html/mailscanner/filter.inc.php and commented out the lines 170 to 186 using /* */, like so:

Code: Select all

170 /*        echo ' <tr><th colspan="2">' . __('stats09') . '</th></tr>' . "\n";
171         $query = "
172 SELECT
173  DATE_FORMAT(MIN(date),'" . DATE_FORMAT . "') AS oldest,
174  DATE_FORMAT(MAX(date),'" . DATE_FORMAT . "') AS newest,
175  COUNT(date) AS messages
176 FROM
177  maillog
178 WHERE
179  1=1
180 " . $this->CreateSQL();
181         $sth = dbquery($query);
182         while ($row = $sth->fetch_object()) {
183             echo ' <tr><td>' . __('oldrecord09') . '</td><td align="right">' . $row->oldest . '</td></tr>' . "\n";
184             echo ' <tr><td>' . __('newrecord09') . '</td><td align="right">' . $row->newest . '</td></tr>' . "\n";
185             echo ' <tr><td>' . __('messagecount09') . '</td><td align="right">' . number_format($row->messages) . '</td></tr>' . "\n";
186         } */

It's useful for me, but not useful enough to make any fuss about it.

If someone else is interested in it, here it is.