Tag: Performance

All the articles with the tag "Performance".

• Cache Eviction Policies: LRU, LFU, FIFO and TTL

  8 Sep, 2026

  By Pratik Bhuite | 23 min read

  Series: Backend Interview Mastery

  Learn cache eviction policies including LRU, LFU, FIFO, and TTL. Choose a policy using workload patterns, memory limits, and production metrics.

  • Backend
  • Caching
  • Redis

• Database Indexing Explained: SQL Examples and Interview Questions

  Updated

  Updated: 30 Aug, 2026

  By Pratik Bhuite | 20 min read

  Series: Database Fundamentals , Backend Interview Mastery

  Learn database indexing with SQL examples: B-tree indexes, query plans, composite index order, write costs, and interview questions.

  • Database
  • SQL
  • Performance

• Offset vs Cursor vs Keyset Pagination for Backend Interviews

  30 Aug, 2026

  By Pratik Bhuite | 12 min read

  Series: Backend Interview Mastery

  Compare offset, cursor, and keyset pagination for backend interviews: performance, consistency, indexes, API contracts, and trade-offs.

  • Backend
  • API Design
  • Databases

• What Is a CDN? How Content Delivery Networks Work

  8 May, 2026

  By Pratik Bhuite | 29 min read

  Series: System Design Foundations

  What is a CDN? Learn how content delivery networks cache content at edge servers, reduce latency, and protect your origin from traffic spikes.

  • System Design
  • CDN
  • Caching