BestHub
Sign in
Tag

with

1 views collected around this technical thread.

Architecture Digest
Architecture Digest
Nov 9, 2024 · Databases

MySQL Query Optimization Techniques and Common Pitfalls

This article examines frequent MySQL performance problems such as inefficient LIMIT pagination, implicit type conversion, sub‑query updates, mixed sorting, misuse of EXISTS, condition push‑down limitations, early result narrowing, intermediate result push‑down, and demonstrates how rewriting queries with JOINs, derived tables, and WITH clauses can dramatically improve execution speed.

IndexJoinMySQL
0 likes · 11 min read
MySQL Query Optimization Techniques and Common Pitfalls
php中文网 Courses
php中文网 Courses
Feb 5, 2024 · Backend Development

Understanding Laravel Eloquent ORM: with vs load Relationship Loading Methods

This article explains Laravel's Eloquent ORM relationship loading methods, comparing the eager-loading `with` function and the lazy-loading `load` function, detailing their mechanisms, advantages, cautions, appropriate use cases, and providing practical code examples for backend developers.

EloquentLaravelLoad
0 likes · 8 min read
Understanding Laravel Eloquent ORM: with vs load Relationship Loading Methods
Sohu Tech Products
Sohu Tech Products
May 31, 2023 · Frontend Development

ECMAScript 2023 New Array Methods: toSorted, toReversed, toSpliced, and with

The ECMAScript 2023 specification introduces four new non‑mutating Array methods—toSorted, toReversed, toSpliced, and with—that let developers work on copies of arrays, improving predictability, easing React state updates, and providing consistent behavior across browsers and runtimes.

Array MethodsECMAScript2023React
0 likes · 12 min read
ECMAScript 2023 New Array Methods: toSorted, toReversed, toSpliced, and with
Sohu Tech Products
Sohu Tech Products
Feb 8, 2023 · Frontend Development

JavaScript's Forgotten Keyword: with

The article explains the obscure JavaScript 'with' keyword, demonstrating its syntax and behavior, detailing how it manipulates the scope chain, and outlining the numerous drawbacks—including strict‑mode prohibition, variable shadowing, security risks, performance penalties, and poor maintainability—that make its use inadvisable.

SecurityStrict Modejavascript
0 likes · 7 min read
JavaScript's Forgotten Keyword: with
vivo Internet Technology
vivo Internet Technology
Oct 30, 2019 · Mobile Development

Kotlin Function Features: Expression Bodies, Named & Default Arguments, Top‑Level & Extension Functions, Lambdas, Member References, with/apply

Kotlin’s function features—including expression bodies, named and default arguments, top‑level and extension functions, local functions, lambdas, member references, and the utility functions with and apply—enable Android developers to write concise, expressive, and boiler‑plate‑free code.

Extension FunctionsKotlinapply
0 likes · 17 min read
Kotlin Function Features: Expression Bodies, Named & Default Arguments, Top‑Level & Extension Functions, Lambdas, Member References, with/apply