# 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.

- Publisher: TechSupport Team
- Canonical page: https://techsupport-team.com/case-studies/property-saas-portal-performance-maintenance/
- Updated: 2026-11-16

Client: KeyStone · Regulated Verticals · UK property SaaS (85 staff)

## 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

## Application stack and tools

### Application stack

- PHP/Laravel→Node.js
- MySQL
- AWS

### Tools used

- Sentry
- Jira
- client mobile analytics

Related services: [Software maintenance](https://techsupport-team.com/services/software-maintenance/)

## 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

Table: Reported results and their measurement scope

| 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](https://techsupport-team.com/contact/) or explore [software maintenance](https://techsupport-team.com/services/software-maintenance/).

## Related pages

- [Software maintenance](https://techsupport-team.com/services/software-maintenance/): The related service for this engagement.

## Contact

Request engineers from TechSupport Team or ask a question: https://techsupport-team.com/contact/
