The Need for Speed
While it’s true you can certainly create a “really fast”, “slick” Single Page Application (no subsequent loading, sorta, we can talk about all those async requests you’re making later). You are bloating not only page size, but the cognitive load (tech debt) of the engineer.
It may not be the silver bullet you’re looking for.
An insanely low-fi website and proper caching, you can reduce your page weight next to nothing, and page reload is insanely fast, if noticeable at all. While a SPA might seem like the gold standard in web development, I’d much prefer a solid software architecture, with lightweight (server side) HTML/CSS backed pages, to a broken, incomplete and lacking (basic links) frontend application. Sprinkle in some JS as needed.
- Speed is the killer feature: https://bdickason.com/posts/speed-is-the-killer-feature/
- Best practices for SQL: https://www.metabase.com/learn/building-analytics/sql-templates/sql-best-practices
- Micro Frontends: https://martinfowler.com/articles/micro-frontends.html