Roxit
A gym platform: memberships, trainer and class booking, rewards, and a Hikvision gate that reads a member code at the door.
- Type
- Client projects
- Stack
- Android, Laravel
- Client
- Roxit
- Year
- 2023 to 2026
- Role
- Backend and Android developer.
The problem
The attendance table passed 1.6 million rows while members kept checking in at the gate, and every sync with the door devices ran inside the request.
What I decided
- Stored a coalesced timestamp once and indexed it, so the daily list filters and sorts on an indexed column instead of a function.
- Removed the N+1 loads on member and referral listings with eager loading and joined queries.
- Moved the Hikvision ISAPI sync to a queue with a scheduler, behind an adapter that retries with backoff.
Where it landed
The platform holds 7,367 members, 1,680,874 check-ins and 80,832 trainer bookings across four outlets, and the attendance list no longer full-scans the table.
All projectsNext project: Foodcourt Sungai Panas
Client systems stay private: no source code, internal URLs or production screenshots appear here. Every figure comes from the repositories or a read-only count on the production database.