New Posts / Get Daily Optimization
Mod Version: 1.00, by Freddie Bingham
This modification is in the archives.
| vB Version: 3.0.1 | Rating:  (2 votes - 5.00 average) |
Installs: 32 |
| Released: 27 Jun 2004 | Last Update: Never | Downloads: 2 |
 Not Supported
|
||
Here is a small 3.0.2 optimization to search.php?do=getnew / search.php?do=getdaily that you can make a noticeable impact on your load.
edit search.php, find:
Above this, place:
For example on vb.com, we went from doing a scan of 107000 thread rows on every getnew/getdaily (that wasn't cached in search.php) to a scan of 188 rows.
edit search.php, find:
PHP Code:
ORDER BY lastpost DESC
PHP Code:
AND sticky IN(0,1)
Download
No files for download.