provider and portable systems: lessons learned (#917)

20 maart 2026 om 18:21:35 Dave Brown

Understanding the Problem

When building modern web applications, performance is not just a feature — it's a requirement. Users expect sub-second response times, and search engines penalize slow pages. This post explores practical techniques for optimization.

Key Metrics

Time to First Byte (TTFB)
Largest Contentful Paint (LCP)
Cumulative Layout Shift (CLS)

"Premature optimization is the root of all evil" — Donald Knuth

However, measured optimization based on profiling data is the root of all performance gains. Let's look at real-world examples.

Database Optimization

-- Before: full table scan
SELECT * FROM posts WHERE status = 'published' ORDER BY created_at DESC;

-- After: indexed query with pagination
SELECT id, title, summary FROM posts
WHERE status = 'published'
ORDER BY created_at DESC
LIMIT 20 OFFSET 0;

The difference? From 850ms to 12ms on a table with 500K rows.

Caching Strategy

Use a multi-layer cache:

L1: In-memory (APCu) — microsecond access
L2: Redis — millisecond access
L3: Database — last resort

Each layer has different TTLs and invalidation strategies.

consectetur incididunt

Inloggen om een reactie toe te voegen

2 reacties

John Doe gereageerd op 20 mrt 2026, 03:22

Ubi est barbatus nix. Vae humani generis. Nulla porta lobortis ligula vel egestas. Diatrias tolerare tanquam noster caesium. Teres talis saepe tractare de camerarius flavum sensorem. Pellentesque et sapien pulvinar consectetur. Ubi est audax amicitia. Abnobas sunt hilotaes de placidus vita. Eros diam egestas libero eu vulputate risus. Mauris dapibus risus quis suscipit vulputate.

Dave Brown gereageerd op 20 mrt 2026, 03:21

Era brevis ratione est. Urna nisl sollicitudin id varius orci quam id turpis. Pellentesque vitae velit ex. Sed varius a risus eget aliquam. Ubi est barbatus nix.

Dit is een voorbeeld applicatie, gemaakt met het Symfony Framework, die je een indruk geeft van de aanbevolen manier om een Symfony applicatie te ontwikkelen.

Voor meer informatie, bekijk de Symfony documentatie.

Klik op deze knop om de broncode te bekijken van de Controller en template, die gebruikt zijn bij het weergeven van deze pagina.

src/Controller/BlogController.php at line 272

/**
 * NOTE: when the controller argument is a Doctrine entity, Symfony makes an
 * automatic database query to fetch it based on the value of the route parameters.
 * The '{slug:post}' configuration tells Symfony to use the 'slug' route
 * parameter in the database query that fetches the entity of the $post argument.
 * This is mostly useful when the route has multiple parameters and the controller
 * also has multiple arguments.
 * See https://symfony.com/doc/current/doctrine.html#automatically-fetching-objects-entityvalueresolver.
 */
#[Route('/posts/{slug:post}', name: 'blog_post', requirements: ['slug' => Requirement::ASCII_SLUG], methods: ['GET'])]
public function postShow(Post $post): Response
{
    // Symfony's 'dump()' function is an improved version of PHP's 'var_dump()' but
    // it's not available in the 'prod' environment to prevent leaking sensitive information.
    // It can be used both in PHP files and Twig templates, but it requires to
    // have enabled the DebugBundle. Uncomment the following line to see it in action:
    //
    // dump($post, $this->getUser(), new \DateTime());
    //
    // The result will be displayed either in the Symfony Profiler or in the stream output.
    // See https://symfony.com/doc/current/profiler.html
    // See https://symfony.com/doc/current/templates.html#the-dump-twig-utilities
    //
    // You can also leverage Symfony's 'dd()' function that dumps and
    // stops the execution

    return $this->render('blog/post_show.html.twig', ['post' => $post]);
}

templates/blog/post_show.html.twig at line 1

Blogberichten RSS