Client: KeyStone · Regulated Verticals · UK property SaaS (85 staff)
Improving Load Times for a Property Portal
TechSupport Team maintained KeyStone’s PHP and MySQL property portal. Over six months, the client’s Sentry records show page-load time falling from 5.4 to 1.8 seconds. Recurring defects in Jira fell from 22 to 6 per quarter.
Client and engagement facts
- Client
- KeyStone
- Industry
- Regulated Verticals
- Business context
- UK property SaaS (85 staff)
- Delivery model
- Software maintenance
- Application
- Property portal with tenant portal
- Supplied geography
- UK
- Company size in source
- 85 staff
Related services: Software maintenance
Application stack and tools
Application stack
- PHP/Laravel→Node.js
- MySQL
- AWS
Tools used
- Sentry
- Jira
- client mobile analytics
Why Support Was Needed
A page load triggered about 40 database queries, and property search queried MySQL directly. The engineers consolidated the repeated queries and moved search to an indexed service.
Technical Work
- Consolidated 40 queries to 6.
- Moved property search from MySQL to a Node.js service with an index.
- Fixed an N+1 query that had been there for two years.
Representative Incident
A CDN outage produced a page-load spike in month four. The team documented the incident and recorded it separately in the maintenance report.
Results and how they were measured
| Metric | Baseline | Result | Units | Measurement window | Source and scope |
|---|---|---|---|---|---|
| Page load | 5.4 s | 1.8 s | s | 6 months | Client Sentry; Scope: The six-month page-load trend excludes the CDN outage. |
| Recurring defects | 22/q | 6/q | /q | 6 months | Client Jira |
| Mobile bounce | 41% | 19% | % | 6 months | Client analytics |
Evidence and Limitations
The six-month page-load trend excludes the CDN outage. The table uses Sentry, Jira and the client’s mobile analytics.
Page Load Investigation
The engineers reduced the query count from 40 to six and moved property search to an indexed service.
Scope a Similar Engagement
Share which pages are slow, how performance is measured and the permission boundaries for repairs. Request a support plan or explore software maintenance.
Get a technical support plan
Tell us which application needs support, what is reaching your engineers and when you need coverage. TechSupport Team will review the fit and explain the next scoping step.
- We reply by email.
- We agree a call about the roles, your stack and the hours.
- If there is a fit, we propose engineers after an assessment.