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.

Has anyone done this hack with the store hack??

Can you post your code?

Hello??

Anyone??

I would really like to run this can anyone help?

For vb3.0 wouldn't it much more efficient to have a separate table for pageviews and make that a heap table in the first place?

Actually, scratch that, heap tables are deleted when machine is rebooted?

I get problems with the search index when using this hack

Database error in vBulletin 2.2.8:

Invalid SQL: DELETE FROM searchindex WHERE wordid IN (0,4218,1488,235788,4322,21662,452,1577,4216,96491 ,52152,1028,2705,176,121,1092,2865,2854,5861) AND postid=300688
mysql error: Can't open file: 'searchindex.MYI'. (errno: 145)

mysql error number: 1016

Date: Friday 16th of January 2004 11:11:17 AM
Script: http://www.sgnonline.com/vb/vb/editpost.php
Referer: http://www.sgnonline.com/vb/editpost...&postid=300688

Could be you ran out of space in your /tmp directory.

Looks more like table corruption. Run myisamchk

A better place for a similar type hack might be attachment.php. Those counters are probably updated much more often than threadviews if you have a lot of attachments in a page.