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

  1. Stored a coalesced timestamp once and indexed it, so the daily list filters and sorts on an indexed column instead of a function.
  2. Removed the N+1 loads on member and referral listings with eager loading and joined queries.
  3. 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.