This hack doesn't touch icons or dates so I don't know where those changes are coming from.

BTW, I've been letting this run for 24 hours between updates:

I can't explain it too - I've looked over the code and the changed code doesn't touch the cookie settings... strange

Just wanted to report that since installing this hack, my load has rarely risen over 1, and I have over 3,000,000 views a month.

Great work, Jujubee!

Kaelon

Jepp, this works just great for me, too.

This stupid threadview-update caused countless "deadlocks" on my machine which resulted in serverloads of 20.0 or even bigger throughout the day ... after installing this hack, the load has never reached a value above 2.50 again.

Great! Thanks! :banana:

nm figured it out :)

BUmp.

So would this work on 2.3.2 without any problem??

Bump.

I installed on 2.3.2 without any problem.

It adds a query: before installing this hack I had 21 queries on showtread, now I have 22 queries.

users online 300-400 server load over 7
there is setting

if ($loadavg[0]<5 && mt_rand(1,600)=='44'){

NIX Load Limit 0 <--- i don't want to be server busy to our users

877 Total Views (original number of write queries)
540 Threads (new number of write queries)

38% of Writes Avoided [337 avoided]
2:1 Original Writes vs. Consolidated Writes

First, I would like to thank you a billion, this has saved us and we see MASSIVE performance gains. We dropped 20 points on the NIX load and no more lagging. We also tested this to work with vBulletin v2.3.2 and 2.2.x. We get 300 to 400 visitors and it was lagging until the database server was overloaded, now we are zooming by most of the time.

We had similar problems, it means that the load average command belongs to root. With PHP's safe mode on, a file belonging to you can not access a file belonging to anyone else including files belonging to root. You will have to ask your server admin to turn of PHP's safe mode.

If you can not turn off safe mode, another solution is to have it read how many processes your SQL login is processing. We had to hack this hack to check that. Actually, we really hacked this hack with a bunch of functions. Maybe I will post the giant hack of this hack later when I have time to refine it a bit.