[Leecher24]

I will say to people that have Big Boards. I have one. More than 1000 Regestritation a Day and over 250000 Thanks at Day.

We must remove this Hack because. If you want Delte some Thread the Script search one Million user Thanks to Delete this. At this moment have the MYSQL Server Load over 50 and it is good Machine ( 4 Socket 4x Quad Xeon 5110 16 GB RAM and 4x SCSI 15k 76 GB with Raid 10).
So the Next I tried to find a Solutions but noby helps here I will pay for this.

But Today I make the SlowQuerry Logging on. And I find very bad think that was produced from the Hidehack on all ShowPost etc. was a Slow Querry from the vB_Thanks:
[HIDE-THANKS]
SELECT thanks.dateline, thread.title, post.postid, user.userid, user.username
FROM vb_thanks as thanks
LEFT JOIN vb_post as post ON (post.postid = thanks.postid)
LEFT JOIN vb_thread as thread ON (thread.threadid = post.threadid)
LEFT JOIN vb_user as user ON (user.userid = thanks.userid)
WHERE post.userid = 1056500
ORDER BY thanks.dateline DESC LIMIT 10;
[/HIDE-THANKS]

One Thousand of this in the Log.
Than I deactivate this Hack and Activate to test that it is 100 Percent the Hidehack here see Statistic :




If someone Thank they Locked the Table vB_user and some processes waiting and Forum give no answer because the MYSQL is overloaded to Process the Thanks Processes

This Hack was fine for a Forum that have max 1000 Thanks a Day or somethink.

If someone like to Rewrite the Hack for better Performance can write me I will pay for this.

Sorry for my english