Hi Swordkill,

I'm getting some bugs when trying to view competition lists. Example to be seen when letting All competitions sort by overall xp descending i get mysql error, so there might be something wrong with the queries or some faults in the database. Hopefully this can be fixed

Greetings.

_________________




I <3 Runetrack

Here's a link to the problem in question: http://runetrack.com/competitions/?type ... ethod=desc

Hi,

It appears that the Competitions table in the database has become so large (250 MB for just that single table), that the sorting actions which require examining every row of the table are unable to be completed. The sorting queries for Tracker ID, Competition, Skill, Start Time, and End Time are all very quick because they refer to individual columns in the table (which can be indexed). However, the Xp Gained, Participants, and Top Competitor sorting queries are much more advanced, because there is no way to determine either of those three without scanning the entire table and calculating each value individually for each of the thousands of competitions (these three values could be set up as their columns, but that would involve quite a bit of new code).

As a temporary solution until I get around to figuring out a better way to sort by Xp Gained, Participants, or Top Competitor, I've now set up the query such that when sorting via these three options, it will only display the results based on the last 1,000 competitions (so sorting All Competitions by Xp Gained will give you the top competition Xp Gains for the latest 1,000 competitions sorted in whatever order you choose). Note that this will only happen when you choose to sort by "All Competitions" or "Finished Competitions", as those are the only two options which have more than 1,000 competitions that could be returned. Additionally, as I previously stated, the sorting queries for Tracker ID, Competition, Skill, Start Time, and End Time are also unaffected and will continue to display results from all selection types in full.

Let me know if you have any questions about this or notice any more issues.

_________________

First off thank you for your reply, i think the final solution would be to add those extra columns in the database but would take a while for the changes to have an effect.

Also I would like to mention that there are still some issues with people being first not ranked then ranked in the overall hiscores. Now a possible fix for this would be storing the number 2 million player with overall xp and then calculate the difference between that and the newly obtained xp or just to have the update avoid players from going to -1 xp to like 2.5m xp for example. As for the other skills the differences are now not that big anymore since the lite scores have updated.

Hopefully you can maybe solve this.

Greetings,
Dutchider.

_________________




I <3 Runetrack

Yes, that is a good point.

I've been hoping for a while that Jagex will do another increase of the RuneScape Highscores, which would be the best solution to these types of problems. The highscores used to only show the top 500,000 players - then, in time Jagex released that wasn't enough, so they raised it to the top 1M. Eventually, in the past couple years, they raised it again to 2M. I think it's about time they raised it to the top 3M, as it's becoming too difficult for the average player to be ranked on the highscores.

There are a few solutions I could implement myself as you mentioned which I may have to look into. However, thankfully this problem is visibly noticeable to anyone viewing the competition tracker - although someone who goes from -1 Overall Xp (unranked) to 17M Overall Xp (the 2M rank mark) could be in first place in the competition, the value in the "Starting Xp" column for them will display as -1 (signaling that they started the competition unranked), so will be obvious that there may be a discrepancy in how much xp they really gained. Knowing this, clan managers can decide how to handle these types of situations themselves, or even plan ahead by verifying unranked participants' starting xp amounts.

_________________

Well regarding that maybe there could be a reset option for competitors and/or a easier way to remove them (more then one per time). Also is there a way to get back to admin panel as i need to relog every time (just an extra button). Greetings

_________________




I <3 Runetrack

This feature has now been added.

_________________

Thank you This may now be closed I will make some more suggestions maybe later regarding the competitions.

_________________




I <3 Runetrack