Bug Leaderboard problem

[trafficmedia]

Hello,

We got a problem, please look at our laderboard:
http://precyl.pl/vbactivity.php?do=leaderboards

Next, look for ranking:
http://precyl.pl/vbactivity.php?do=ranking

We can see differences between the results, so we have the impression as if the leaderboard was not at all "refreshed"

Please check te inssue.

 

[Cosmic]

Hello,

We got a problem, please look at our laderboard:
http://precyl.pl/vbactivity.php?do=leaderboards

Next, look for ranking:
http://precyl.pl/vbactivity.php?do=ranking

We can see differences between the results, so we have the impression as if the leaderboard was not at all "refreshed"

Please check te inssue.

We are unable to see that, could you please post screenshots?

Thanks

 

[trafficmedia]

Hello,

Please login at username: dragonbyte password: dragonbyte00

Best regards

 

[Fillip H.]

That user does not have permission to view the vBActivity pages.

 

[trafficmedia]

Please check now.

Querying the entire table (all records) - in our case it is 2 000 000 members, is unacceptable and will automatically lead to an excessive overload of the database.
We have over 2 000 000 users, so you can reduce ranking and leaderboard LIMIT to 0,50 ?

Best regards

 

[Fillip H.]

It does not query the entire user table, both those pages include LIMIT
By default, Leaderboards limits to 5 users and ranking limits to 25 users.

What lead you to believe that it queried it all?

In addition, your forum loads extremely slow, it took 2-3 minutes to load your forum home page.

I would strongly suggest adding vbactivity.php to your vBSEO exclusion list, vBSEO has been the source behind most of our support tickets that have been about slow loading times.

 

[trafficmedia]

It does not query the entire user table, both those pages include LIMIT
By default, Leaderboards limits to 5 users and ranking limits to 25 users.
Sorry - only at this moment (we run cron jobs)

What lead you to believe that it queried it all?
http://img262.imageshack.us/img262/9358/zrzutekranu20101228godzu.png - pagination
In addition, your forum loads extremely slow, it took 2-3 minutes to load your forum home page.
Yes, above - we have mass run cron job

I would strongly suggest adding vbactivity.php to your vBSEO exclusion list, vBSEO has been the source behind most of our support tickets that have been about slow loading times.
OK.

Please give me a information about how it works - ranking and leaderboard generating a lot of time.

 

[trafficmedia]

We do not want to display users who have zero posts are not logged at all - completely misses it with our goal

 

[Fillip H.]

Ranking:

1. Determines sort order based on input
2. Counts total number of included users (this is a safe operation, Member List operates in the same way)
3. Selects users based on what page of rankings you are at (limited to 25 users)
4. Fetches and formats points / activity levels
5. Prints page

Leaderboards:

1. Does 1 small query per "points type" - by default, this is approx 44 but on your forum it is only 16 due to your settings (It is always better to run several small queries than one BIG one.) - Limited to 5 users by default.
2. Formats points
3. Prints page

 

[trafficmedia]

Thank for your reply.

We have exluded basic usergroups (the most users) in the leaderboard:
http://img510.imageshack.us/img510/4884/zrzutekranu20101228godz.png

And our leaderboard page take a lot of time to generate (above 5 min and timeouted) so why?
What we can do to optimize leaderboard and ranking display?

Best regards,
T

 

[Fillip H.]

My best advice would be to seek out a MySQL Configuration expert and have them optimise your my.cnf file.

You can post a config optimisation request in this forum: http://www.vbulletin.com/forum/forumdisplay.php/14-Server-Configuration
Please remember to read the stickies so that you provide them with the information they need before helping you

 

[trafficmedia]

I was afraid I would get this type of answer

Servers are fine, always optimizing - forum works very efficiently. The problem is only with the leaderboard and ranking system - whether or not we can optimize these two modules?

 

[Cosmic]

If the tips Fillip H. has given you (e.g adding VBA to the VBSEO exclusion list) does not appear to help, please try disabling vBSEO temporarily to see if this resolves the problem.

VBSEO is notorious for causing load and interfering with other modifications, more or less all of our load tickets (and according to a friend at vbulletin.com THEIR load issue tickets) are caused by VBSEO. Obviously if another modification is causing the problem, theres not much we can do about it.

 

[trafficmedia]

If the tips Fillip H. has given you (e.g adding VBA to the VBSEO exclusion list) does not appear to help, please try disabling vBSEO temporarily to see if this resolves the problem.

VBSEO is notorious for causing load and interfering with other modifications, more or less all of our load tickets (and according to a friend at vbulletin.com THEIR load issue tickets) are caused by VBSEO. Obviously if another modification is causing the problem, theres not much we can do about it.

VBA has been added to exclusion list, but not a matter of overall performance, but here is that we can not call the leaderboard through the browser.
Server load and overall performace is ok (incrased 5 - 7 %)

Please try to view leaderboard: http://precyl.pl/vbactivity.php?do=leaderboards

 

[Cosmic]

VBA has been added to exclusion list, but not a matter of overall performance, but here is that we can not call the leaderboard through the browser.
Server load and overall performace is ok (incrased 5 - 7 %)

Please try to view leaderboard: http://precyl.pl/vbactivity.php?do=leaderboards

I am unable to load your sites homepage at the moment (or any other page).

It looks as though you are having server issues?

Cosmic

EDIT: Just an update, tried loading it again after a few minutes and both your homepage and the leaderboards page are loading absolutely fine.

What issue is it you are having that is occuring *only* on the leaderboard page?

 

[trafficmedia]

These are not problems with the server - again, we got to the time at which cron rebulid sphinx search and runing other cron jobs.

I have prepare link for you, please look at this:
http://www.webpagetest.org/result/101228_CX_6R56/
Above leaderboard (sometimes timeouted)

Performace issue - i trying to load ranking or leaderboard page, sometimes timeouted (a lot of data loaded) or long load time.
Im looking for help with optimize leaderboard and ranking on BIG BOARDS.

Best regards,
T

 

[Fillip H.]

There's nothing further that can be done for big boards AFAIK, we have other similarily sized boards which run the Leaderboards and Ranking with absolutely no problem whatsoever

 

[Cosmic]

Looking at your results suggests VBA is actually not the problem: http://www.webpagetest.org/result/101228_CX_6R56/3/details/

vbactivity.php accounts for 1.5seconds of your load time, the other 4.5 is generic site content.

You'll notice most of your loadtime coms from images, which are loading very slowly for you. This suggests you either have very large images, or your hard disk is being overworked and cannot handle the volume of data.

You can also see that your server is being hammered for image requests, despite the javascript being larger in filesize it's actually having significantly LESS impact than your images.

I suggest you re-run the test at the same time for 3 different pages (leaderboards, site home, and another random page on your site) and you will see that the leaderboards are not causing any extra load at all =)

You might want to get someone who specialises in server optimisation to look over your results - from those you posted it seems whoever is in charge just now is giving you poor advice if they said vba was the issue.

Cosmic