jeffalo @jeffalo

amogus

Jul 24, 2021, 11:36 AM
48
View all Parent

comments

Highlighted comment
lily @lily Jul 27, 2021, 8:59 AM

extra thingy for 2. that is just literally all users sorted by top followers limited to I think 10
-krios- @-krios- Jul 27, 2021, 4:12 PM

Ok. I wonder why note more than ten? @Jeffalo!!! Can you hear me? Is there a reason the explore is limited to ten?
-krios- @-krios- Jul 27, 2021, 4:12 PM

*not
jeffalo @jeffalo Jul 28, 2021, 6:06 AM

the calculation to sort users by followers is very heavy.. if i added more it would cause strain on my servers which wouldn't be very cool. (also its 15, not 10, because 15 is divisible by 3)
-krios- @-krios- Jul 29, 2021, 6:15 PM

ok.
lily @lily Jul 31, 2021, 9:37 AM

why does it have to be divisible by 3

also what is heavy about SELECT * FROM Users ORDER Followers LIMIT 15;
jeffalo @jeffalo Jul 31, 2021, 9:57 AM

well it's a grid of 3 users, and the heavy part is its not stored like that. also sorting is hard

lily @lily Aug 3, 2021, 6:45 PM

oh