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.

[Boofo]

Will this work on RC3 for now? Once 3.0.2 gets released, I plan on upgrading (that is if 3.0.3 isn't just around the corner).

[Freddie Bingham]

Originally Posted by Boofo

Will this work on RC3 for now? Once 3.0.2 gets released, I plan on upgrading (that is if 3.0.3 isn't just around the corner).

It will work on any version of 3.0 that you have access to.

[SnowBot]

This is nice of you to post

I think vBulletin should tell the users now what mods they have made to the files as most people have hacked the boards and dont want to rehack everything once an upgrade comes out. There cant be that many things to do and most people who have hacked there boards can make the file edits with the new 3.0.2 corrections.

food for thought

[Freddie Bingham]

Originally Posted by SnowBot

This is nice of you to post

I think vBulletin should tell the users now what mods they have made to the files as most people have hacked the boards and dont want to rehack everything once an upgrade comes out. There cant be that many things to do and most people who have hacked there boards can make the file edits with the new 3.0.2 corrections.

food for thought

Our policies are not for discussion here.

[Boofo]

Originally Posted by Freddie Bingham

It will work on any version of 3.0 that you have access to.

Thank you, Freddie.

This is already added to 3.0.2, right?

[P.Jackson]

no doubt

[the Sandman]

Thanks Freddie!

[colicab-d]

is 3.0.2 out? Ive not seen it

[the Sandman]

It's not out... yet...