Case Study · Home Remodeling · Performance & Scheduling

Years of Leads and Sales. Searched in Milliseconds, Not Minutes.

Unique Home Solutions, Cleveland Ohio's trusted home-remodeling company, had built a SugarCRM database spanning several gigabytes of leads, sales, and appointments across windows, siding, roofing, bath remodeling, and more. Vertekx rebuilt the system's core to keep it fast at that scale, and layered in scheduling and reporting built for how a multi-crew remodeling business runs.

SugarCRMFull Text SearchJasperReportsiReport

MillisecondsResponse times held low across a multi-gigabyte database

Full Text SearchCore database engine updated and wired into Global Search

Two Sites, One PipelineBoth websites feed leads into the same system

The Challenge

A database large enough to slow itself down

Years of leads, sales, and appointments across every product line, windows, siding, roofing, bath remodeling, cabinets, waterproofing, gutters, and doors, had built a SugarCRM database spanning several gigabytes.

At that scale, a standard installation starts to show its age: searches slow down, standard reporting can't answer the questions a remodeling business actually asks, and scheduling across many crews and active projects needs more structure than a generic calendar provides.

Search that draggedAcross a multi-gigabyte database, both Global Search and in-module search had slowed down.

Reports that couldn't answerStandard reporting didn't address the specific operational questions a remodeling business asks.

Scheduling without structureAppointments across crews, projects, and product lines needed more than a stock calendar could offer.

Two websites, one pipelineLeads from two separate sites needed to feed one system without becoming two separate problems.

The Solution

Rebuilt for speed, scheduled for the field

The system's core was rebuilt to stay fast at scale, with scheduling and reporting layered on top to match how a remodeling business really runs.

Full text search at scaleThe core database engine was updated for full text search, tuned to hold response times in milliseconds even against a multi-gigabyte dataset.

Instant Global SearchThat full text search was wired directly into Global Search, so any record across the system surfaces instantly.

Calendars built for the workCustom calendars for Project Tasks and Cases match how installation and service appointments actually get scheduled, with time-block logging on top.

Reports that fit the businessA custom reporting layer on JasperReports and iReport answers the operational questions standard reports couldn't.

The Results

Fast again, and built to stay that way

MinutesMilliseconds

Full text search now returns any record across a multi-gigabyte database in milliseconds, across leads, sales, and appointments alike.

Full textSearch wired into Global SearchAny record across every module surfaces instantly, not just within one screen.

Multi-GBFast at production scaleResponse times held in milliseconds against a database several gigabytes deep.

2 → 1Two sites, one pipelineBoth websites feed the same system, without becoming two separate problems.

Fast at any scale. A database that had grown large enough to slow itself down now returns full text search results in milliseconds, across leads, sales, and appointments alike, with scheduling and reporting built around how a multi-crew, multi-product remodeling business actually operates.

Also Delivered

Dashboards tuned to the work

Alongside the core build, these capabilities shipped as part of the system too.

Customized dashlets tuned to the metrics the business watches most

Outgrowing your CRM's performance as it grows?

If your database has gotten large enough to slow you down, let's talk about keeping it fast at any scale.

Get a Free Consultation