Saanora for Windows

Always. Give me the symptom and the table size and we’ll work backwards from there.

Timeline widgets almost always sort by created_at inside one tenant, which is exactly where this tends to go wrong.

Find the bottleneck

Run EXPLAIN (ANALYZE, BUFFERS)first. It’s almost always one of three shapes:

• Seq Scan on orders — no usable index, so all 40M rows get read.
• Rows Removed by Filter in the thousands — the index is too broad.
• Sort with disk in the method — you outgrew work_mem.

The fix that usually holds

A composite index in selectivity order, built without blocking writes:

CREATE INDEX CONCURRENTLY idx_orders_tenant_created
  ON orders (tenant_id, created_at DESC)
  INCLUDE (status, total_cents);

That turns the Seq Scan into an Index Only Scan. Run ANALYZE orders after.

Then anchor it on generation share rather than installed capacity — capacity flatters solar, and your LPs will know it.

Kepler’s third law: orbital period grows with the 3/2 power of the radius, so distance costs time faster than it costs space.

Orbital radii are true to scale; the bodies are enlarged ~2,000× or Mercury would be a single pixel.

Mercury sits at 0.39 AU, Earth at 1.0, Mars at 1.52 — the gaps widen fast, which is why a Mars transfer window only opens every 26 months.

Here’s a small, typed useDebouncedValue — it works for any value, not just strings, and cleans up after itself:

export function useDebouncedValue<T>(value: T, delay = 300) {
  const [debounced, setDebounced] = useState(value);

  useEffect(() => {
    // Reset the timer on every change — only the last value lands.
    const t = setTimeout(() => setDebounced(value), delay);
    return () => clearTimeout(t);
  }, [value, delay]);

  return debounced;
}

Using it

• Search-as-you-type — useDebouncedValue(query, 300), then fetch on the debounced value, not the raw one.
• Generic on purpose — debounce filters, sliders, or a whole form object the same way.

Want the fetch side too? I can add an AbortController so stale requests cancel themselves.

Five questions, exam style. You get the explanation after each one — and anything you miss becomes a flashcard at the end.