New Posts / Get Daily Optimization

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:

PHP Code:

ORDER BY lastpost DESC 


Above this, place:

PHP Code:

AND sticky IN(0,1) 


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.

[sabret00the]

nice work, that's a major optimisation right there

[nuno]

Originally Posted by Freddie Bingham

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:

PHP Code:

ORDER BY lastpost DESC 


Above this, place:

PHP Code:

AND sticky IN(0,1) 


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.

God bless you, dear!

[MindTrix]

Nice little addition thanks

[Vega]

Nice one!

Thx.

[Cold Steel]

Installed - thanks!

[Freddie Bingham]

Originally Posted by colicab-d

is 3.0.2 out? Ive not seen it

3.0.2 is not out yet but I assumed that this little change would be helpful now.

[SnowBot]

Originally Posted by Freddie Bingham

Our policies are not for discussion here.

I didnt say i wanted to :P I just stated my views.

[PET]

uhh...i just upgrade to 3.0.1 and now i hear 3.0.2

[Oblivion Knight]

Thanks Freddie..

[tamarian]

My "check daily" went from about 1 second to about 0.1 seconds!!

Well done, installed.