Can this site use the SQL COUNT or limit results to avoid freezing or crashing my browser on profiles with 1000+ runs?
17 days ago

I play some fighting games but I can't view the most prolific runners' profiles without risking freezing or crashing my browser. Like, say, DBcade - Speedrun.com and FelipeNascimento83 - Speedrun.com. On Windows 10 PC, sometimes a page loads in a few seconds and sometime never. My phone stops loading results at 2 games.

The answer is at hand. I did this at my job. You can limit the number of results straight from the SQL query. You can also use a COUNT command to determine the number of results which runs very fast because it doesn't return any rows of data. You can even return a partial list of the results to display on one page, versus getting the whole 1000+ dataset and paginating the whole thing. Maybe have a different protocol for mobile users.

jackzfiml, EXPL en 2 anderen vindt dit leuk
Andalusia, Spain

I hope the staff listen to this, i have the same issue, and i like the "profiles pages" thing, it could be nice to limit it to 500 runs per page or something like that

btw @Akuretaki is an example of a SRC profile that my pc can't load and makes my browser crash, but there's a lot more people

Bewerkt door de auteur 16 days ago
EXPL, NewSchoolBoxer, en Akuretaki vindt dit leuk
Pennsylvania, USA

I think another possible solution is to do what they do with big leaderboards and load runs one page at a time

NewSchoolBoxer, EXPL, en YUMmy_Bacon5 vindt dit leuk