BestHub
Sign in
Tagged articles
141 articles
Page 2 of 2
Java Captain
Java Captain
Sep 26, 2020 · Databases

MySQL Performance Optimization Techniques: LIMIT, Implicit Conversion, Join Rewrite, Mixed Sorting, EXISTS, Condition Pushdown, and More

This article explains common MySQL performance pitfalls such as large OFFSET in LIMIT clauses, implicit type conversion, sub‑query updates, mixed sorting, EXISTS usage, condition push‑down limitations, and demonstrates how rewriting queries with indexes, JOINs, UNION ALL, and WITH clauses can dramatically reduce execution time.

IndexesJoinMySQL
0 likes · 14 min read
MySQL Performance Optimization Techniques: LIMIT, Implicit Conversion, Join Rewrite, Mixed Sorting, EXISTS, Condition Pushdown, and More
Big Data Technology Architecture
Big Data Technology Architecture
Aug 5, 2020 · Big Data

Understanding Join Execution in Spark SQL

This article explains how Spark SQL processes joins—including inner, outer, semi, and anti joins—by describing the overall query planning flow, the three physical join strategies (sort‑merge, broadcast, and hash), and the specific implementation details for each join type.

DataFramesDistributed computingJoin
0 likes · 10 min read
Understanding Join Execution in Spark SQL
Big Data Technology & Architecture
Big Data Technology & Architecture
Aug 3, 2020 · Big Data

Understanding Join Implementations in Spark SQL

This article explains the various join types supported by Spark SQL, describes the overall Spark SQL execution flow, and details the physical implementation processes of inner, outer, semi, anti, broadcast, sort‑merge, and hash joins, helping developers grasp how joins are executed in a distributed environment.

Distributed computingJoindataframe
0 likes · 12 min read
Understanding Join Implementations in Spark SQL
Architecture Digest
Architecture Digest
Jun 21, 2020 · Databases

Optimizing Large-Scale MySQL Join Queries Using EXPLAIN

This article explains how to analyze and tune MySQL join queries with EXPLAIN, addressing issues like using temporary tables and filesort, and provides practical techniques—including STRAIGHT_JOIN and index strategies—to achieve sub‑second response times on tables with millions of rows.

Database PerformanceEXPLAINJoin
0 likes · 6 min read
Optimizing Large-Scale MySQL Join Queries Using EXPLAIN
Programmer DD
Programmer DD
Jun 18, 2020 · Databases

How to Optimize MySQL Joins for Million‑Row Tables in Under 2 Seconds

This article explains how to use EXPLAIN to analyze MySQL join queries, identifies causes of temporary tables and filesorts, and provides practical techniques—including driver‑table selection, STRAIGHT_JOIN usage, and index strategies—to optimize two‑ and multi‑table joins so that million‑row results return within two seconds.

Database PerformanceEXPLAINJoin
0 likes · 8 min read
How to Optimize MySQL Joins for Million‑Row Tables in Under 2 Seconds
ITPUB
ITPUB
Jun 15, 2020 · Databases

Why Does Alibaba's Java Manual Ban Joins Over Three Tables? A Deep Performance Dive

This article investigates Alibaba's recommendation against joining more than three MySQL tables by designing experiments with synthetic data, measuring query performance on MySQL and Oracle, analyzing index impact, and providing full DDL and data‑generation scripts to explain the rule's practical limits.

Data GenerationJoinMySQL
0 likes · 11 min read
Why Does Alibaba's Java Manual Ban Joins Over Three Tables? A Deep Performance Dive
Selected Java Interview Questions
Selected Java Interview Questions
Jun 5, 2020 · Databases

MySQL Query Optimization Techniques and Common Pitfalls

This article explains MySQL execution order, highlights performance problems with large OFFSET LIMIT queries, demonstrates how implicit type conversion, sub‑query rewriting, EXISTS removal, condition push‑down, and intermediate result push‑down can dramatically improve query speed, and provides practical SQL rewrite examples.

DatabaseIndexesJoin
0 likes · 13 min read
MySQL Query Optimization Techniques and Common Pitfalls
ITPUB
ITPUB
Jun 3, 2020 · Databases

Why MySQL Ignored My Index: Charset Mismatch Triggers Full Table Scans

A MySQL join between a large and a small table ran for seconds because differing character sets forced implicit conversions that disabled the index, and the article shows how to diagnose the issue with EXPLAIN, fix it by aligning charsets, and avoid similar pitfalls.

CharsetJoinMySQL
0 likes · 7 min read
Why MySQL Ignored My Index: Charset Mismatch Triggers Full Table Scans
Java Backend Technology
Java Backend Technology
Apr 23, 2020 · Databases

Why MySQL LIMIT Can Reverse ORDER BY in LEFT JOIN Queries

The author discovers a puzzling MySQL bug where moving the LIMIT clause outside a nested SELECT causes the final result set to be ordered incorrectly, explains how ORDER BY inside subqueries is ignored during LEFT JOIN processing, and recommends placing ORDER BY and LIMIT at the outermost query level.

JoinLIMITMySQL
0 likes · 5 min read
Why MySQL LIMIT Can Reverse ORDER BY in LEFT JOIN Queries
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
IT Architects Alliance
IT Architects Alliance
Nov 21, 2019 · Databases

Why MySQL Subqueries Took Hours and How Indexes Fixed It

A MySQL 5.6 database with three large tables suffered a 30,000‑second query when searching for students scoring 100 in a specific subject; by analyzing the execution plan, adding indexes on filter columns, and rewriting the query as a join, execution time dropped to under a second.

JoinMySQLSQL optimization
0 likes · 8 min read
Why MySQL Subqueries Took Hours and How Indexes Fixed It
21CTO
21CTO
Nov 21, 2019 · Databases

How I Reduced a 30,000‑second MySQL Query to 0.001s with Indexes & Joins

This article walks through a real‑world MySQL performance case where a nested sub‑query on millions of rows took over eight hours, explains why the plan used full table scans, and shows step‑by‑step index creation and query rewrites that cut the execution time to a millisecond.

IndexesJoinMySQL
0 likes · 7 min read
How I Reduced a 30,000‑second MySQL Query to 0.001s with Indexes & Joins
Big Data Technology & Architecture
Big Data Technology & Architecture
Nov 14, 2019 · Big Data

Comparison of Flink and Spark Structured Streaming: Joins, State Management, Fault Tolerance, and Backpressure

This article compares Flink and Spark Structured Streaming, detailing their differences in join capabilities, state management, fault‑tolerance mechanisms, exactly‑once semantics, back‑pressure handling, and table registration, while providing code examples and practical insights for real‑time big‑data processing.

Big DataFlinkJoin
0 likes · 13 min read
Comparison of Flink and Spark Structured Streaming: Joins, State Management, Fault Tolerance, and Backpressure
Tech Musings
Tech Musings
Oct 31, 2019 · Databases

Master MySQL Tricks: Upserts, Ignoring Errors, Joins, Pagination & More

This guide explores advanced MySQL techniques—including ON DUPLICATE KEY UPDATE for upserts, INSERT IGNORE to bypass errors, replacing subqueries with JOINs, handling LEFT JOIN pitfalls, efficient pagination strategies, multi‑table UPDATE/DELETE via JOIN, and the nuances of COUNT(*) versus COUNT(1).

COUNTDatabase OptimizationJoin
0 likes · 12 min read
Master MySQL Tricks: Upserts, Ignoring Errors, Joins, Pagination & More
Java Captain
Java Captain
Aug 7, 2019 · Databases

Practical Guide to Group, Join, and CASE WHEN Queries in SQL

This article provides a beginner‑friendly, step‑by‑step tutorial on common SQL operations—including GROUP BY aggregation, JOIN types, CASE WHEN expressions, and useful built‑in functions—illustrated with clear examples, typical pitfalls, and ready‑to‑use code snippets.

CASE WHENDatabase tutorialFunctions
0 likes · 10 min read
Practical Guide to Group, Join, and CASE WHEN Queries in SQL
Efficient Ops
Efficient Ops
Jun 28, 2019 · Databases

Master MySQL Optimization: 19 Practical EXPLAIN Tips and Best Practices

This guide presents nineteen essential MySQL optimization techniques—including effective use of EXPLAIN, proper handling of IN and EXISTS, avoiding SELECT *, limiting rows, optimizing ORDER BY, leveraging UNION ALL, employing full‑text indexes, and advanced join strategies—to help developers write faster, more efficient queries.

EXPLAINIndexesJoin
0 likes · 12 min read
Master MySQL Optimization: 19 Practical EXPLAIN Tips and Best Practices
MaGe Linux Operations
MaGe Linux Operations
Apr 16, 2019 · Fundamentals

8 Powerful Ways to Concatenate Strings in Python

This article presents a comprehensive overview of eight different techniques for joining strings in Python, covering simple operators, formatting methods, built‑in functions, and best‑practice recommendations for both small and large concatenations.

JoinPythonString concatenation
0 likes · 4 min read
8 Powerful Ways to Concatenate Strings in Python
58 Tech
58 Tech
Mar 15, 2019 · Big Data

Optimizing Spark Join Operations in Spark Core and Spark SQL

This article explains how to improve Spark join performance by reducing shuffle, using appropriate partitioners, applying broadcast hash joins for small tables, and selecting the optimal join strategy (broadcast, shuffle hash, or sort‑merge) in both Spark Core and Spark SQL.

JoinOptimizationShuffle
0 likes · 6 min read
Optimizing Spark Join Operations in Spark Core and Spark SQL
MaGe Linux Operations
MaGe Linux Operations
Feb 24, 2019 · Fundamentals

7 Efficient Ways to Concatenate Strings in Python

This article reviews seven common Python string‑concatenation techniques—including +, commas, direct literals, %, format(), join(), f‑strings, and *—and explains when each method is most suitable for small or large string assemblies.

JoinString concatenationf-string
0 likes · 4 min read
7 Efficient Ways to Concatenate Strings in Python
Liangxu Linux
Liangxu Linux
Feb 20, 2019 · Databases

19 Essential MySQL Optimization Techniques Every Developer Should Know

This guide presents 19 practical MySQL optimization tips—including using EXPLAIN, avoiding SELECT *, limiting IN lists, preferring UNION ALL, improving pagination, leveraging full‑text indexes, and proper join strategies—to help developers write faster, more efficient queries.

EXPLAINFull-Text SearchJoin
0 likes · 12 min read
19 Essential MySQL Optimization Techniques Every Developer Should Know
Java Captain
Java Captain
Feb 16, 2019 · Databases

Seven SQL JOIN Types Explained with Example Queries

The article explains seven SQL join techniques—including INNER, LEFT, RIGHT, FULL OUTER, and their exclusive variants—illustrated with diagrams and accompanied by complete SELECT statements that demonstrate how to combine rows from two tables based on matching keys.

DatabaseINNER JOINJoin
0 likes · 3 min read
Seven SQL JOIN Types Explained with Example Queries
MaGe Linux Operations
MaGe Linux Operations
Jan 17, 2019 · Fundamentals

7 Powerful Ways to Concatenate Strings in Python

This article reviews seven common Python string concatenation techniques—including the plus operator, commas, direct literals, the % operator, format(), f-strings, join(), and the multiplication operator—highlighting their syntax, use cases, and performance considerations for both small and large strings.

JoinString concatenationf-string
0 likes · 4 min read
7 Powerful Ways to Concatenate Strings in Python
ITPUB
ITPUB
Nov 27, 2018 · Databases

Boost MySQL Performance: Field Types, JOIN vs Subqueries, UNION, and Transactions

This guide presents four practical MySQL performance‑boosting techniques—selecting optimal column types, replacing sub‑queries with JOINs, using UNION instead of temporary tables, and employing transactions with BEGIN/COMMIT/ROLLBACK—to make queries faster and ensure data integrity.

Database TuningJoinMySQL
0 likes · 6 min read
Boost MySQL Performance: Field Types, JOIN vs Subqueries, UNION, and Transactions
MaGe Linux Operations
MaGe Linux Operations
Jul 7, 2018 · Fundamentals

8 Powerful Ways to Concatenate Strings in Python

This guide reviews eight common Python string concatenation techniques—including the plus operator, commas, direct literals, percent formatting, format(), f-strings, join(), and the multiplication operator—highlighting their syntax, use cases, performance considerations, and recommendations for small versus large string assemblies.

JoinString concatenationf-string
0 likes · 4 min read
8 Powerful Ways to Concatenate Strings in Python
ITPUB
ITPUB
Apr 25, 2018 · Databases

Optimizing Large-Scale Joins with Oracle Temporary Tables: Strategies & Pitfalls

Facing a 20‑million‑row master table and millions of rows in up to ten child tables, the article examines the inefficiencies of repeated IN‑clause queries and presents three alternative strategies—including a single‑SQL join, a UNION ALL view, and the use of global temporary tables—detailing their trade‑offs and experimental results.

JoinOracleSQL optimization
0 likes · 10 min read
Optimizing Large-Scale Joins with Oracle Temporary Tables: Strategies & Pitfalls
ITPUB
ITPUB
Feb 23, 2017 · Databases

Mastering SQL Joins: From CROSS to LATERAL and Beyond

This comprehensive guide explains every major SQL join type—including CROSS, INNER, OUTER, FULL, SEMI, ANTI, LATERAL, and MULTISET—detailing their logical behavior, practical use‑cases, alternative syntaxes, performance implications, and visual examples across PostgreSQL, Oracle, and SQL Server.

DatabaseJoinOracle
0 likes · 22 min read
Mastering SQL Joins: From CROSS to LATERAL and Beyond