Syntax - Tasty Web Development Treats cover image

Syntax - Tasty Web Development Treats

708: How We Made Syntax.fm Faster

Dec 25, 2023
27:36
Snipd AI
The hosts discuss improving the performance of the Syntax.fm website, including caching, loading transcripts, and optimizing database calls. They also talk about the benefits of using Apollo and Apollo GraphQL, as well as solving issues with LinkedIn using Redis caching.
Read more

Podcast summary created with Snipd AI

Quick takeaways

  • Identifying performance issues through the eye test, web vitals, and database query analysis helped prioritize areas for improvement.
  • Optimizing the loading of transcripts by separating it into its own route and leveraging nested layout routing significantly improved loading time and reduced unnecessary database queries.

Deep dives

Identifying Performance Issues and Metrics

The hosts of the podcast discuss how they identified the performance issues on their website by using the eye test, web vitals, and database query analysis through tools like Sentry. They focused on the slowest routes of the site and analyzed metrics such as time to first byte and opportunity score to prioritize areas for improvement. They also used the queries feature to identify slow database queries and discovered an easy fix by switching from 'find first' to 'find unique' method in Prisma.

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode