# Refactoring a SQL Table at Scale: Lessons from Harness CI

DevFeed: [Refactoring a SQL Table at Scale: Lessons from Harness CI](<https://devfeed.tech/articles/refactoring-a-sql-table-at-scale-lessons-from-harness-ci-13449.md>)

Original publisher: [Read original article](<https://www.harness.io/blog/lessons-from-refactoring-at-scale>)

Author: Moshe Tsur

Published: 2026-08-06T00:00:00Z

Content type: article

Language: en

Sources: [Harness Blog](<https://devfeed.tech/sources/harness-blog.md>)

Topics: [Refactoring](<https://devfeed.tech/topics/refactoring.md>), [Structured-data](<https://devfeed.tech/topics/structured-data.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Latency](<https://devfeed.tech/topics/latency.md>), [API](<https://devfeed.tech/topics/api.md>), [ci](<https://devfeed.tech/topics/ci.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [continuous-integration](<https://devfeed.tech/tags/continuous-integration.md>), [harness](<https://devfeed.tech/tags/harness.md>), [latency](<https://devfeed.tech/tags/latency.md>), [refactoring](<https://devfeed.tech/tags/refactoring.md>), [schema](<https://devfeed.tech/tags/schema.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

Harness describes refactoring a flat SQL table used for CI test results into a normalized schema. The article reports reducing storage per row from 400 bytes to 28 bytes and making API latency constant at any scale.

## Source excerpt

How Harness refactored a flat SQL table into a normalized schema, cutting storage per row from 400 bytes to 28 bytes and making API latency constant at any scal | Blog