Skip to main content
Back to Blog
performance speed lists optimization

17x Faster Large Lists

Swifty Team Feb 19, 2026 3 min read

Performance is a feature. When a list view takes three seconds to load, every navigation to that view takes three seconds away from productive work. For teams that navigate lists dozens of times per day — order queues, customer lists, inventory views — the accumulated cost is significant.

A 17x improvement in large list performance is not an incremental optimization. It's a qualitative change in how the platform feels to use.

What Changed

Large list performance was bottlenecked by two compounding problems: the query that fetched records was doing more work than necessary, and the data being transmitted to the browser included fields that weren't visible in the current column configuration.

The optimization addressed both. Query planning was improved to fetch only what the current view needs — the columns selected by the user, plus sort and filter fields. Data transmission was reduced by stripping fields excluded from the current view before sending the response.

The result is smaller queries, smaller responses, and faster rendering — the three factors that determine how quickly a list appears after you navigate to it.

Numbers in Context

A list of 5,000 records with 8 visible columns previously took approximately 2.8 seconds to load. After optimization, the same view loads in under 170 milliseconds.

That's not a perceived improvement from better caching or loading indicators. The data arrives faster. The list renders faster. The improvement is real and measurable.

Consistent Across Volume

The optimization scales. A 500-record list improves proportionally. A 50,000-record list (which renders paginated, but still requires counting and fetching the right page) improves proportionally.

Volume isn't the exception case. For operations with large datasets — high-volume order management, large customer bases, comprehensive inventory — performance at scale is the daily reality, not a stress test scenario.

The Downstream Effects

Faster lists change behavior. Teams that avoided navigating to large lists because they were slow now navigate to them freely. Reports that needed to be run as background jobs because viewing them interactively was impractical are now usable in real time.

When the tool gets out of the way, work moves faster. The 17x improvement is a number; the actual impact is less friction, more flow, and time returned to the team.

Related posts

Composed Data Sources

Chain and relate data sources for rich dashboards — compose complex data views from simpler sources without writing code.

Computed Expressions

Transform data with template expressions and built-in functions — format, combine, and derive values from your data without code.

Cross-Source Data Joins

Combine data from multiple sources in one view — join records from your database with data from external services using a shared key.