BestHub
Sign in
Tagged articles
8 articles
Page 1 of 1
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.

JOINLIMITSQL Optimization
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
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.

JavaScriptScope ChainWITH
0 likes · 7 min read
JavaScript's Forgotten Keyword: with
Java Architect Essentials
Java Architect Essentials
Jun 18, 2021 · Databases

How to Supercharge MySQL Queries: 8 Proven Optimization Techniques

This article walks through eight common MySQL performance pitfalls—including inefficient LIMIT usage, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, condition push‑down, early range reduction, and intermediate result push‑down—and shows how to rewrite each query to achieve dramatic speed improvements, often reducing execution time from seconds to milliseconds.

Condition PushdownJOINSQL Optimization
0 likes · 14 min read
How to Supercharge MySQL Queries: 8 Proven Optimization Techniques
ITPUB
ITPUB
Dec 30, 2019 · Databases

8 Proven MySQL Tricks to Supercharge Your Queries

This article presents eight practical MySQL optimization techniques—including smarter LIMIT usage, implicit type conversion fixes, join rewrites, mixed sorting, EXISTS elimination, condition pushdown, early row limiting, and intermediate result pushdown—each illustrated with SQL examples and performance comparisons that reduce query times from seconds to milliseconds.

EXISTSJOINLIMIT
0 likes · 13 min read
8 Proven MySQL Tricks to Supercharge Your Queries
Liangxu Linux
Liangxu Linux
Dec 23, 2019 · Databases

Boost MySQL Performance: Practical Tips for LIMIT, Implicit Conversion, Joins, and More

This article presents concrete MySQL optimization techniques—including smarter LIMIT usage, avoiding implicit type conversion, rewriting updates and deletes with JOINs, handling mixed ordering, replacing EXISTS with joins, pushing down conditions, and leveraging WITH clauses—to dramatically reduce query execution times from seconds to milliseconds.

EXISTSJOINLIMIT
0 likes · 14 min read
Boost MySQL Performance: Practical Tips for LIMIT, Implicit Conversion, Joins, and More
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 FunctionsKotlinLambda
0 likes · 17 min read
Kotlin Function Features: Expression Bodies, Named & Default Arguments, Top‑Level & Extension Functions, Lambdas, Member References, with/apply