Productrise is nine months old, and it has been growing fast. Thousands of queries are tracked every day, and hundreds of thousands of products are audited and optimized through the platform. That growth is exciting, but it also puts real pressure on performance. Today we are rolling out a round of database optimizations that make some of your heaviest reports load dramatically faster.
A quick look under the hood
When I started building Productrise, I had one guiding rule: don't lock yourself into a database schema you will later regret. So the platform was built around compute-on-read. Any calculation the platform needed was done on demand, by the code or your browser, at the moment you loaded a report.
This approach has one big advantage: your databases stay clean of computed fields. A bloated database runs fine with light usage, but once you are storing millions of rows, that bloat compounds into a serious problem. Keeping things lean early on was the right call.
From compute-on-read to compute-on-write
Productrise has now entered the phase where the databases need to be optimized further for performance. So parts of the back-end now run on compute-on-write instead. Calculations happen the moment data is written to the database, and the results are stored in what are called roll-up tables.
When you open a dashboard, the page now reads precomputed data straight from these roll-up tables, rather than crunching every value from raw data while you wait.
What you will notice
The difference is especially clear on query group reports and the queries overview. Both run heavy computations in the background, calculating position scores across all SERPs for every query loaded on the page.
Loading a query groups report with six months of data across 100 queries used to mean staring at a loading screen for well over a minute. That wait is now gone.
To be fair, pulling that much data onto a single page still takes real resources, so please don't expect lightning speed on the very heaviest reports. :-)
From a technical standpoint, this marks the start of a new phase for Productrise, where a growing user base is matched by a growing infrastructure. There is more of this to come.