Optimizing Yii 2 ActiveRecord: Choosing between with() and joinWith()
Stop the N+1 query problem in Yii 2. Learn when to use with() for separate queries versus joinWith() for single JOINs, including critical column aliasing tips.
Loading…
ReadMeFeed / Community knowledge
#performance
Real questions. Useful conversations. Find the people who know your stack.
yiiChoosing Between InstancedMesh and Thin Instances in Babylon.js 6.x
Decide between Babylon.js InstancedMesh and Thin Instances for large-scale identical objects. Compare CPU overhead, draw calls, picking, animation support, and memory with a concrete 50k-box example and validation steps.
babylonjsReducing Database Load with Elixir ETS for Transient State
Learn how to use Elixir ETS (Erlang Term Storage) to reduce database load by caching transient state in-memory with O(1) lookup performance.
elixirIn-place updates with data.table's := operator: a practical guide
Learn how data.table's := operator updates columns in place, avoiding copies and speeding up grouped manipulations on large R datasets.
rEnabling Hermes in a Bare Workflow React Native Project for Faster Startup
Learn how to turn on Hermes, measure its impact on launch time and memory, and understand the trade‑offs involved.
androidStop the N+1 Nightmare: Mastering Django’s select_related and prefetch_related
Learn how Django’s select_related and prefetch_related solve the N+1 query problem. A step‑by‑step example with Book, Author, and Tag models shows query counts before and after optimization, plus trade‑offs to watch out for.
djangoMemcached's Slab Allocator: Why Your Cache Wastes Memory on Purpose
Memcached's slab allocator trades memory utilization for predictable latency. Here's how slab classes work, why eviction is per-class, and how to measure your actual waste with stats slabs.
memcachedSpeeding Up Notebook Calculations with Wolfram Language's ParallelMap
Learn when and how to use Wolfram Language's ParallelMap to spread CPU-bound notebook work across local kernels, with a worked example, limitations, and a verification checklist.
Lazy‑Loading StencilJS Components with the @Load Decorator
Learn how to split your StencilJS bundle at runtime using @Load, see a working parent‑child example, and verify the impact on initial load size and network behavior.
stenciljs