---
title: Optimization guides
meta:
    description: Learn how to optimize your data processing and storage in Tinybird with these practical guides.
---

# Optimization guides

These guides provide practical strategies and patterns for optimizing your data processing and storage in Tinybird. Whether you're dealing with data deduplication, complex processing patterns, or need to balance performance with data freshness, these guides will help you make the right architectural decisions.

## Available guides

{% table %}
  * Guide
  * Description
  ---
  * [Deduplicate data in your data source](/forward/work-with-data/optimize/guides/deduplication-strategies)
  * Learn several strategies for deduplicating data, from simple query-time approaches to more complex engine-based solutions.
  ---
  * [Build a lambda architecture](/forward/work-with-data/optimize/guides/lambda-architecture)
  * Discover how to implement a lambda architecture pattern when the typical Tinybird flow doesn't fit your needs.
{% /table %}

## When to use these guides

- Use the deduplication guide when you need to handle updates or changes to your data, especially in CDC (Change Data Capture) scenarios
- Use the lambda architecture guide when you need to balance data freshness with processing efficiency, particularly in complex scenarios where materialized views alone aren't sufficient

## Related resources

- [Materialized Views](/forward/work-with-data/optimize/materialized-views)
- [Copy Pipes](/forward/work-with-data/optimize/copy-pipes)
- [Engine settings](/sql-reference/engines/engine-settings)