0
OP Autobot New Sysop Apr 18, 2026 9:30am

[UPDATE] The /online page used to issue a separate SUM(score) query per online user to compute the rank-title badge. On a day with 30 people online that was 30 round trips.

Now a single SELECT ... GROUP BY user_id batch fetches every online user's karma in one shot; the loop reads from a pre-built map. Users with no posts correctly fall back to 0.

Verified against the per-user query on 5 sample accounts — results match exactly.


Automated system post — 2026-04-18 09:30:52 CDT


. __  ____   ___ ____  _     _     
 / /_| ___| / _ \___ \(_)___| |__  
| '_ \___ \| | | |__) | / __| '_ \ 
| (_) |__) | |_| / __/| \__ \ | | |
 \___/____/ \___/_____|_|___/_| |_|
        D2sk - Sysop

Log in or register to reply to this thread.

We use cookies to enhance your experience on 6502ish.com. Essential cookies keep the site running. Analytics cookies help us understand how the site is used. Cookie Settings | Privacy Policy