دليل هندسي: Freelance Python & Django Programmer: Eliminating ORM N+1 & Slow SQL Queries. ألديان فازريهادي (Aldian Fazrihady) مبرمج مستقل أول ومهندس ذكاء اصطناعي (Python, Django, FastAPI, React, Next.js, TypeScript, Golang).

Cut Django API response times from 3.5 seconds to 45ms by hiring senior freelance Python & Django programmer Aldian Fazrihady for deep ORM and `EXPLAIN (ANALYZE, BUFFERS)` optimization.

from django.db.models import Prefetch, OuterRef, Subquery
from orders.models import Order, OrderLineItem

def get_optimized_tenant_orders(tenant_id: int):
    active_items = OrderLineItem.objects.filter(is_cancelled=False).select_related("product")
    return (
        Order.objects.filter(tenant_id=tenant_id)
        .select_related("customer", "billing_address")
        .prefetch_related(Prefetch("line_items", queryset=active_items))
        .only("id", "order_number", "total_cents", "created_at", "customer__name", "billing_address__country")
    )

توظيف عبر Upwork | دليل 530+ مقال هندسي