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:

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.

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.

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.

Thank you, Freddie. ;)

This is already added to 3.0.2, right?

no doubt :)

Thanks Freddie!

is 3.0.2 out? Ive not seen it

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