Question 1

How does Polars LazyFrame query optimization work?

Accepted Answer

**Target Audience:** Developers who have used Polars (or pandas) and want to explain what the lazy API does under the hood.
**Difficulty:** Medium
**Python version:** The two examples are standard-library toy engines that run in the page (Pyodide 0.25.1, CPython 3.11.3) and were checked on CPython 3.11. **Polars itself was not installed in our verification environment**, so Polars snippets here were not run; Polars behaviour is described from the Polars user guide and API reference, cited inline

Question 2

How do you measure and profile Python performance?

Accepted Answer

**Target Audience:** Developers who have heard "profile before you optimise" but never actually read a profiler table; no prior performance work assumed.
**Difficulty:** Medium
**Python version:** Examples run on CPython 3.11 (python3.11 and the in-page Pyodide 0.25.1 runtime, CPython 3.11.3). The command-line profiles were run on python3.11 and python3.12 on our machine; their timings are from that run only.

> **How to read this doc:** Each idea is explained in plain language first, then tagge

Question 3

When should you still use multiprocessing vs free-threaded threads in Python 3.12+?

Accepted Answer

**Target Audience:** Developers who know threads, processes and the GIL at a basic level and must choose a concurrency model for CPU-bound Python work.
**Difficulty:** Medium
**Python version:** Example 1 runs in the page on Pyodide 0.25.1 (CPython 3.11.3) and was checked on CPython 3.11. Example 2 starts threads and processes, so it was run on CPython 3.13 (default build). **We did not have a free-threaded interpreter**, so performance claims about it come from the CPython docs and PEPs cited i

PYTHONDECODED.

Medium

How does Polars LazyFrame query optimization work?

How do you measure and profile Python performance?

When should you still use multiprocessing vs free-threaded threads in Python 3.12+?