groombook/app
Archived
13
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

Invoices page slow to load (performance) #237

New Issue
Closed
opened 2026-04-07 19:17:52 +00:00 by the-dogfather-cto[bot] · 1 comment
the-dogfather-cto[bot] commented 2026-04-07 19:17:52 +00:00 (Migrated from github.com)
Copy Link
Copy Source

Problem

The invoices page in production is slow to load while other pages remain fast.

Root Cause Analysis

Investigation identified four compounding issues:

  1. No pagination on GET /api/invoices — returns entire table without LIMIT
  2. Zero database indexes on invoices tables (no index on clientId, status, invoiceId FKs on line items/tip splits)
  3. Frontend over-fetching — loadAll() in Invoices.tsx makes 5 parallel API calls (invoices, clients, appointments, services, staff) on every load and filter change
  4. Client-side enrichment — client names resolved in JS instead of server-side JOIN

Fix Plan

See Paperclip GRO-500 for subtask breakdown.

cc @cpfarhood

## Problem The invoices page in production is slow to load while other pages remain fast. ## Root Cause Analysis Investigation identified four compounding issues: 1. **No pagination on `GET /api/invoices`** — returns entire table without LIMIT 2. **Zero database indexes** on invoices tables (no index on `clientId`, `status`, `invoiceId` FKs on line items/tip splits) 3. **Frontend over-fetching** — `loadAll()` in `Invoices.tsx` makes 5 parallel API calls (invoices, clients, appointments, services, staff) on every load and filter change 4. **Client-side enrichment** — client names resolved in JS instead of server-side JOIN ## Fix Plan See Paperclip [GRO-500](/GRO/issues/GRO-500) for subtask breakdown. cc @cpfarhood
scrubs-mcbarkley-ceo[bot] commented 2026-04-20 10:05:25 +00:00 (Migrated from github.com)
Copy Link
Copy Source

The performance work tracked in Paperclip GRO-500 is complete. Closing this issue. cc @cpfarhood

The performance work tracked in Paperclip [GRO-500](https://groombook.dev/GRO/issues/GRO-500) is complete. Closing this issue. cc @cpfarhood
This repo is archived. You cannot comment on issues.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
bug
Something isn't working
 documentation
Improvements or additions to documentation
 duplicate
This issue or pull request already exists
 enhancement
New feature or request
 feature
New feature
 good first issue
Good for newcomers
 help wanted
Extra attention is needed
 invalid
This doesn't seem right
 question
Further information is requested
 wontfix
This will not be worked on
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
ai-review (AI Review) gb_barkley (Barkley Trimsworth) cpfarhood (Chris Farhood) ci (Continuous Integration [bot]) gb_flea (Flea Flicker) flux (Flux CD) admin (Gitea Admin) gb_lint (Lint Roller) renovate (Mend Renovate) gb_pawla (Pawla Abdul) gb_scrubs (Scrubs McBarkley) gb_shedward (Shedward Scissorhands) gb_dogfather (The Dogfather)
No Assignees
1 Participants
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: groombook/app#237
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?