BestHub
Sign in
Tagged articles

SQL

2879 articles · Page 7 of 29
Programmer1970
Programmer1970
Sep 22, 2024 · Backend Development

15 Proven Techniques to Optimize API Performance

This article enumerates fifteen practical techniques—including local and distributed caching, parallelism, asynchrony, pooling, sharding, SQL tuning, pre‑computation, transaction trimming, bulk I/O, lock granularity, context propagation, collection sizing, and query optimization—to systematically improve the response time and throughput of service interfaces.

APIAsynchronousSQL
0 likes · 14 min read
15 Proven Techniques to Optimize API Performance
Liangxu Linux
Liangxu Linux
Sep 19, 2024 · Databases

10 Advanced SQL Concepts Every Data Scientist Should Master

This guide walks through ten essential advanced SQL techniques—including CTEs, recursive CTEs, temporary functions, CASE‑WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking functions, delta calculations with LAG/LEAD, cumulative sums, and date‑time manipulation—to help data professionals ace interview challenges and write cleaner, more powerful queries.

Advanced SQLCTEDatabase
0 likes · 11 min read
10 Advanced SQL Concepts Every Data Scientist Should Master
macrozheng
macrozheng
Sep 19, 2024 · Databases

Why LEFT JOIN Still Returns All Left Rows: ON vs WHERE Explained

This article explains why a LEFT JOIN always returns all rows from the left table, clarifies the difference between ON and WHERE clauses, demonstrates the behavior with multiple SQL examples and code snippets, and highlights the special handling of LEFT/RIGHT/FULL joins versus inner joins.

DatabaseLeft JoinON clause
0 likes · 6 min read
Why LEFT JOIN Still Returns All Left Rows: ON vs WHERE Explained
Architect's Guide
Architect's Guide
Sep 19, 2024 · Databases

Understanding LEFT JOIN ON vs WHERE Conditions in SQL

This article explains why adding conditions after a LEFT JOIN's ON clause does not filter rows, contrasts ON and WHERE behavior, and demonstrates the effect with multiple SQL examples and visual illustrations of temporary tables and join semantics.

Join TypesLeft JoinON clause
0 likes · 6 min read
Understanding LEFT JOIN ON vs WHERE Conditions in SQL
21CTO
21CTO
Sep 17, 2024 · Databases

MariaDB’s Journey: From MySQL Fork to K1 Private Equity Takeover

The article traces MariaDB’s evolution from its MySQL roots and community‑driven development, through its NYSE listing, financial performance, restructuring, and the recent K1 Investment Management acquisition, while highlighting key figures, product features, and industry reactions.

DatabaseMariaDBSQL
0 likes · 12 min read
MariaDB’s Journey: From MySQL Fork to K1 Private Equity Takeover
ITPUB
ITPUB
Sep 15, 2024 · Databases

Does Varchar Length Affect MySQL Storage and Query Performance? A Practical Test

This article investigates whether defining a VARCHAR column with a larger length (e.g., VARCHAR(500) vs VARCHAR(50)) changes storage consumption and query speed in MySQL by creating two identical tables, inserting one million rows, measuring space usage, and benchmarking various SELECT and ORDER BY operations.

MySQLPerformanceSQL
0 likes · 10 min read
Does Varchar Length Affect MySQL Storage and Query Performance? A Practical Test
MaGe Linux Operations
MaGe Linux Operations
Sep 11, 2024 · Databases

Master MySQL Upgrade: Key Tips, Commands, and Common Pitfalls

This guide details essential MySQL upgrade considerations, backup warnings, version‑specific changes, and step‑by‑step procedures for both in‑place and logical migrations, helping administrators safely move from MySQL 5.6 to 5.7 while avoiding common pitfalls.

Database MigrationLogicalMySQL
0 likes · 7 min read
Master MySQL Upgrade: Key Tips, Commands, and Common Pitfalls
Liangxu Linux
Liangxu Linux
Sep 10, 2024 · Databases

Essential MySQL Scripts for Export, Import, and Database Management

This guide provides a comprehensive collection of MySQL command‑line scripts covering database and table export/import, creation, deletion, schema inspection, data manipulation, user privilege management, and common DDL operations, all with practical examples.

DDLData manipulationDatabase
0 likes · 10 min read
Essential MySQL Scripts for Export, Import, and Database Management
IT Services Circle
IT Services Circle
Sep 10, 2024 · Databases

Understanding MySQL Indexes: Types, Structures, and Optimization Techniques

This article provides a comprehensive overview of MySQL indexing, covering index classifications, B+Tree and Hash structures, primary and secondary (clustered and non‑clustered) indexes, covering index push‑down, index merge, covering indexes, cost‑based index selection, and common pitfalls that cause index inefficiency.

DatabaseMySQLPerformance
0 likes · 27 min read
Understanding MySQL Indexes: Types, Structures, and Optimization Techniques
Baidu Geek Talk
Baidu Geek Talk
Sep 9, 2024 · Big Data

TDS Platform Overview: Architecture, Modules, and Features of Baidu MEG's Turing 3.0 Data Ecosystem

The TDS platform, central to Baidu MEG’s Turing 3.0 ecosystem, unifies data development, warehouse management, monitoring, and resource control through Spark‑based TDE, a visual studio, and AI‑enhanced tools like Smart Diagnosis and Text2SQL, enabling standardized workflows, scalable scheduling, and handling over 30 k daily tasks.

AIBig DataData Development
0 likes · 21 min read
TDS Platform Overview: Architecture, Modules, and Features of Baidu MEG's Turing 3.0 Data Ecosystem
21CTO
21CTO
Sep 7, 2024 · Frontend Development

What’s New in VS Code 1.93? ESM Migration, SQL Fixes, and Enhanced IntelliSense

The VS Code 1.93 release brings a major shift to ESM modules, fixes SQL language highlighting, adds configuration file UI improvements, introduces Django test support, and enhances IntelliSense and experimental network inspection for JavaScript and Node.js developers.

DjangoESMIntelliSense
0 likes · 6 min read
What’s New in VS Code 1.93? ESM Migration, SQL Fixes, and Enhanced IntelliSense
php Courses
php Courses
Sep 6, 2024 · Backend Development

How to Use mysqli_fetch_assoc in PHP to Retrieve Query Results

This tutorial explains how to connect to a MySQL database using PHP's mysqli extension, execute queries, and retrieve results with mysqli_fetch_assoc, providing step-by-step code examples for connection, querying, and a complete script.

MySQLMySQLiSQL
0 likes · 4 min read
How to Use mysqli_fetch_assoc in PHP to Retrieve Query Results
Sohu Tech Products
Sohu Tech Products
Sep 5, 2024 · Databases

How to Diagnose and Resolve MySQL InnoDB Deadlocks: A Step-by-Step Guide

This article walks through a real‑world MySQL InnoDB deadlock case, detailing log analysis, reproducing the issue with test data, explaining gap and insert‑intention locks, and presenting a practical solution that checks existence before updating or inserting to prevent deadlocks.

Database PerformanceDeadlockInnoDB
0 likes · 14 min read
How to Diagnose and Resolve MySQL InnoDB Deadlocks: A Step-by-Step Guide
dbaplus Community
dbaplus Community
Sep 5, 2024 · Databases

How to Migrate Data from MongoDB to MySQL Using DuckDB

This guide explains how to export MongoDB collections to JSON, load them into DuckDB, generate compatible table schemas, and then transfer the data efficiently into MySQL using DuckDB as an intermediate processing engine.

Data MigrationDuckDBETL
0 likes · 6 min read
How to Migrate Data from MongoDB to MySQL Using DuckDB
StarRocks
StarRocks
Sep 5, 2024 · Big Data

Accelerate Lakehouse Queries: A Hands‑On Guide to StarRocks + Apache Iceberg

This tutorial walks you through the fundamentals of Apache Iceberg, its architecture and key features, explains why it’s advantageous for lakehouse workloads, and provides a step‑by‑step Docker‑Compose setup to integrate Iceberg with StarRocks for fast, ACID‑compliant analytics on real‑world taxi data.

Apache IcebergDockerLakehouse
0 likes · 15 min read
Accelerate Lakehouse Queries: A Hands‑On Guide to StarRocks + Apache Iceberg
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Sep 5, 2024 · Databases

Understanding Database Deadlocks: Causes, Scenarios, and Effective Solutions

This article explains what database deadlocks are, illustrates typical deadlock scenarios, outlines common causes such as resource competition and unordered locking, and presents practical solutions including timeout mechanisms, consistent lock ordering, deadlock detection, lock granularity reduction, and optimistic concurrency control, complemented by example SQL code.

SQL
0 likes · 7 min read
Understanding Database Deadlocks: Causes, Scenarios, and Effective Solutions
Alibaba Cloud Native
Alibaba Cloud Native
Sep 4, 2024 · Big Data

How to Speed Up High‑Cardinality GroupBy Queries by Up to 8× in SLS

This article explains why high‑cardinality GroupBy queries are slow, describes SLS's underlying aggregation pipeline, and shows how adjusting session parameters and enabling high‑cardinality optimizations can reduce query times from dozens of seconds to just a few seconds across three real‑world test scenarios.

SLSSQLbig-data
0 likes · 11 min read
How to Speed Up High‑Cardinality GroupBy Queries by Up to 8× in SLS
Selected Java Interview Questions
Selected Java Interview Questions
Sep 2, 2024 · Databases

Optimizing Full‑Table Updates in MySQL with Row‑Based Binlog: Strategies and Best Practices

This article explains the challenges of executing full‑table UPDATE statements on large MySQL tables using row‑based binlog replication, analyzes deep pagination issues, and presents a batch‑processing strategy with FORCE INDEX, SQL_NO_CACHE and controlled rate limiting to safely migrate data at scale.

Full Table UpdateMySQLPagination
0 likes · 8 min read
Optimizing Full‑Table Updates in MySQL with Row‑Based Binlog: Strategies and Best Practices
dbaplus Community
dbaplus Community
Sep 1, 2024 · Databases

How Do Oracle’s SQL Management Features Stack Up Against Domestic Databases?

The article examines Oracle’s comprehensive SQL management capabilities—such as parsing, plan caching, process tracing, execution plan handling, optimization, and runtime monitoring—and compares them with the features offered by major Chinese and open‑source databases, highlighting gaps, strengths, and practical recommendations for adopting domestic solutions.

Database ManagementDomestic databasesOracle
0 likes · 12 min read
How Do Oracle’s SQL Management Features Stack Up Against Domestic Databases?
ITPUB
ITPUB
Sep 1, 2024 · Databases

Why MySQL’s != on Nullable Indexed Columns Returns Unexpected Results

This article demonstrates how a non‑unique indexed column that allows NULL values behaves with the != operator in MySQL, showing why null rows are omitted from result sets, how index usage changes, and how to rewrite queries with OR or UNION to obtain correct results while preserving performance.

EXPLAINIndexMySQL
0 likes · 6 min read
Why MySQL’s != on Nullable Indexed Columns Returns Unexpected Results
IT Services Circle
IT Services Circle
Aug 30, 2024 · Backend Development

Technical Interview Q&A: C++ vs Go, Thread Communication, Goroutine, TCP Handshake, SQL, and More

This article compiles a series of technical interview questions and answers covering C++ and Go language differences, thread communication methods on Linux and Windows, stack versus heap memory, orphan processes, read‑write locks, Go goroutine concurrency, TCP three‑way handshake, and a sample SQL query for gender‑based grouping.

C++GoOperating Systems
0 likes · 12 min read
Technical Interview Q&A: C++ vs Go, Thread Communication, Goroutine, TCP Handshake, SQL, and More
ITPUB
ITPUB
Aug 25, 2024 · Databases

How to Allocate Train Seats Across Segments Using SQL

This article recounts L's attempt to change a train ticket, analyzes seat availability across four segments, and presents a minimal SQL model with table creation, data insertion, and a query that determines feasible seat combinations, demonstrating how segment‑wise seat allocation can enable complete journey booking.

DatabaseOracleSQL
0 likes · 9 min read
How to Allocate Train Seats Across Segments Using SQL
Python Programming Learning Circle
Python Programming Learning Circle
Aug 23, 2024 · Artificial Intelligence

Getting Started with Python Generative AI: Six Practical Projects Using Llama 2, LangChain, Streamlit, Gradio, FastAPI and SQL

This article presents six hands‑on Python generative‑AI projects—ranging from a Llama 2 chatbot built with Streamlit and Replicate to natural‑language‑to‑SQL conversion using LlamaIndex and SQLAlchemy—complete with environment setup, required code snippets, deployment tips and resource links for further exploration.

FastAPIGradioLangChain
0 likes · 20 min read
Getting Started with Python Generative AI: Six Practical Projects Using Llama 2, LangChain, Streamlit, Gradio, FastAPI and SQL
JD Tech
JD Tech
Aug 19, 2024 · Databases

Understanding MySQL Indexes: Models, Maintenance, Utilization, and Optimization

This article explains MySQL index fundamentals—including hash tables, ordered arrays, and B+‑tree structures—covers index maintenance, demonstrates how indexes improve query execution, discusses best practices such as left‑most prefix, covering indexes, index push‑down, and unique indexes, and provides practical tips for index selection, avoiding index loss, and using EXPLAIN for performance tuning.

B+TreeIndexSQL
0 likes · 17 min read
Understanding MySQL Indexes: Models, Maintenance, Utilization, and Optimization
ITPUB
ITPUB
Aug 18, 2024 · Databases

When to Use Database Stored Procedures? Pros, Cons, and Best Practices

This article examines the advantages and disadvantages of using stored procedures in relational databases, discusses common pitfalls and vendor‑specific issues, provides guidance for Oracle stored procedures, and offers practical recommendations on when and how to apply them effectively.

OracleSQLStored Procedures
0 likes · 5 min read
When to Use Database Stored Procedures? Pros, Cons, and Best Practices
StarRocks
StarRocks
Aug 14, 2024 · Big Data

Mastering StarRocks & Apache Paimon: A Fast‑Track Lakehouse Guide

This guide provides a comprehensive overview of Apache Paimon’s architecture, key features, and advantages, explains how to integrate it with StarRocks for real‑time lakehouse analytics, and walks through a complete quick‑start setup including component installation, Flink and Kafka deployment, data ingestion, table creation, and query execution with time‑travel support.

Apache PaimonFlinkKafka
0 likes · 18 min read
Mastering StarRocks & Apache Paimon: A Fast‑Track Lakehouse Guide
IT Services Circle
IT Services Circle
Aug 13, 2024 · Backend Development

Implementing Pull‑Down Pagination for Instant Messaging History

This article explains the challenges of loading historical chat messages in an instant‑messaging app and demonstrates why traditional offset pagination fails, then introduces cursor‑based pagination with SQL examples and best‑practice guidelines for reliable incremental loading.

Cursor PaginationInstant MessagingSQL
0 likes · 7 min read
Implementing Pull‑Down Pagination for Instant Messaging History
StarRocks
StarRocks
Aug 9, 2024 · Big Data

How Pinterest Cut Query Latency by 50% with StarRocks Migration

Pinterest migrated its Partner Insights analytics from Druid to StarRocks, achieving a 50% reduction in p90 latency, a six‑fold cost‑performance improvement, and simplified data ingestion, illustrating the benefits of a modern MPP database for real‑time ad analytics.

AnalyticsMPPPinterest
0 likes · 6 min read
How Pinterest Cut Query Latency by 50% with StarRocks Migration
21CTO
21CTO
Aug 8, 2024 · Databases

Why SQL Will Outlast NoSQL: Lessons from 20 Years of Database Evolution

Despite the hype around NoSQL, this article argues that SQL and relational databases remain the superior choice for transactional data, tracing two decades of research, highlighting the limitations of NoSQL, and showing how modern databases now incorporate the best features of both worlds.

ACIDDatabase ArchitectureNoSQL
0 likes · 9 min read
Why SQL Will Outlast NoSQL: Lessons from 20 Years of Database Evolution
Volcano Engine Developer Services
Volcano Engine Developer Services
Aug 6, 2024 · Artificial Intelligence

How an AI-Powered Bot Turns Excel Files into Interactive Reports

This article introduces an AI‑driven Smart Report Assistant Bot that automatically converts uploaded Excel files into recommended charts, allows users to customize reports, and details the underlying workflow—including Excel parsing, LLM‑generated SQL, dynamic table creation, chart rendering with ECharts, and image‑merging plugins.

AIBotECharts
0 likes · 8 min read
How an AI-Powered Bot Turns Excel Files into Interactive Reports
Java Architect Essentials
Java Architect Essentials
Aug 2, 2024 · Databases

Migrating a SpringBoot + MyBatisPlus + MySQL Project to PostgreSQL: Common Pitfalls and Helper Scripts

This article details the step‑by‑step process of switching a SpringBoot‑MyBatisPlus application from MySQL to PostgreSQL, covering driver integration, JDBC configuration changes, numerous SQL and type‑conversion pitfalls, and provides ready‑to‑run PostgreSQL scripts for bulk column adjustments and default values.

Database MigrationJavaMySQL
0 likes · 11 min read
Migrating a SpringBoot + MyBatisPlus + MySQL Project to PostgreSQL: Common Pitfalls and Helper Scripts
php Courses
php Courses
Aug 2, 2024 · Backend Development

Using PHP mysqli_query to Execute MySQL Queries

This article introduces the PHP mysqli_query function, demonstrates how to connect to a MySQL database, execute SELECT, INSERT, UPDATE, and DELETE statements, and explains result handling with example code, providing a concise guide for backend developers working with relational databases.

MySQLSQLmysqli_query
0 likes · 4 min read
Using PHP mysqli_query to Execute MySQL Queries
php Courses
php Courses
Aug 2, 2024 · Backend Development

Optimizing WordPress Database Performance with Advanced PHP Techniques

This comprehensive guide explains how to boost WordPress site speed and SEO by applying PHP‑based strategies such as query optimization, regular database maintenance, custom tables, option‑table tuning, indexing, and caching, complete with practical code examples.

PerformanceSQLWordPress
0 likes · 9 min read
Optimizing WordPress Database Performance with Advanced PHP Techniques
21CTO
21CTO
Jul 30, 2024 · Databases

What Goes Around: 20‑Year Evolution of Database Systems and Future Trends

This article reviews two decades of database research, analyzing the rise and decline of various data models—from hierarchical and relational to NoSQL, vector, and graph databases—while highlighting how AI, cloud, and hardware advances are reshaping DBMS architecture and predicting which approaches will dominate tomorrow’s data landscape.

DBMS EvolutionNoSQLSQL
0 likes · 30 min read
What Goes Around: 20‑Year Evolution of Database Systems and Future Trends
ITPUB
ITPUB
Jul 27, 2024 · Databases

How to Diagnose and Optimize Extremely Slow MySQL Queries

This article explains what constitutes a slow SQL query, how to detect and analyze it using MySQL tools, and provides practical optimization steps—including indexing, business logic review, caching, scheduling, and partitioning—to dramatically reduce execution time.

DatabaseIndexingMySQL
0 likes · 7 min read
How to Diagnose and Optimize Extremely Slow MySQL Queries
Top Architect
Top Architect
Jul 24, 2024 · Databases

Top 20 SQL Optimization Techniques for Better Query Performance

This article presents twenty practical SQL optimization techniques—including index usage, selective column queries, avoiding functions in WHERE clauses, replacing subqueries with joins, limiting result sets, using EXISTS, batch inserts, covering indexes, proper data types, pagination, and transaction management—to significantly improve query performance and database efficiency.

Performance TuningSQLbest practices
0 likes · 11 min read
Top 20 SQL Optimization Techniques for Better Query Performance
Programmer DD
Programmer DD
Jul 24, 2024 · Databases

Designing a Google Calendar Clone: Step‑by‑Step Database Modeling Tutorial

This tutorial walks through designing a complete logical and physical database model for a Google Calendar clone, covering entities, attributes, relationships, handling all‑day and time events, recurrence rules, slots, and SQL table creation, while illustrating minimal‑modeling techniques.

SQLcalendar appdatabase-design
0 likes · 41 min read
Designing a Google Calendar Clone: Step‑by‑Step Database Modeling Tutorial
Architecture & Thinking
Architecture & Thinking
Jul 24, 2024 · Databases

Why MySQL Pagination Slows Down and How to Speed It Up

This article examines why MySQL pagination using large LIMIT OFFSET values becomes increasingly slow, explains the underlying scanning behavior, and presents six practical optimization techniques—including indexed subqueries, cursor‑based pagination, column selection, partitioning, caching, and hardware considerations—to dramatically improve query performance on massive tables.

DatabaseMySQLOptimization
0 likes · 7 min read
Why MySQL Pagination Slows Down and How to Speed It Up
Senior Tony
Senior Tony
Jul 20, 2024 · Databases

How MySQL’s Skip Scan Defies the Leftmost Prefix Rule

This article explains MySQL’s composite index leftmost‑prefix rule, demonstrates how the Skip Scan Range Access Method introduced in MySQL 8.0.13 can use indexes without following the rule, provides step‑by‑step examples, code snippets, and discusses its implementation, benefits, and limitations.

Composite IndexMySQLSQL
0 likes · 10 min read
How MySQL’s Skip Scan Defies the Leftmost Prefix Rule
DeWu Technology
DeWu Technology
Jul 17, 2024 · Backend Development

BPMN Overview and SmartEngine Implementation for Workflow Optimization

Covering workflow history, this article explains BPMN standards, outlines core modeling concepts, and demonstrates a practical SmartEngine integration that deploys BPMN 2.0 XML, highlights visual execution benefits, notes limitations in error handling and concurrency, and advises its use for moderately complex, frequently changing processes.

BPMNJavaSQL
0 likes · 24 min read
BPMN Overview and SmartEngine Implementation for Workflow Optimization
Selected Java Interview Questions
Selected Java Interview Questions
Jul 16, 2024 · Databases

SQL Query Optimization Techniques

This article explains how to speed up SQL queries while keeping statements concise, covering the query processing workflow, optimization goals, and practical tips such as selecting specific columns, avoiding DISTINCT, using proper indexes, preferring EXISTS over COUNT, limiting result sets, favoring WHERE over HAVING, and replacing correlated subqueries with joins.

DatabaseQuery OptimizationSQL
0 likes · 9 min read
SQL Query Optimization Techniques
ITPUB
ITPUB
Jul 13, 2024 · Databases

How One SQL Crashed a Core System for 12 Hours – Oracle Performance Troubleshooting

A single runaway SQL caused a 12‑hour outage of a core Oracle system; the article walks through the fault symptoms, AWR and ASH analysis, abnormal SQL identification, execution‑plan changes caused by partition operations, and the step‑by‑step remediation that restored performance.

AWRDirect Path ReadOracle
0 likes · 8 min read
How One SQL Crashed a Core System for 12 Hours – Oracle Performance Troubleshooting
Top Architect
Top Architect
Jul 10, 2024 · Backend Development

Optimizing a High-Concurrency Interface: Reducing Response Time from 30 s to 0.8 s with SQL Refactoring and Caffeine Caching

This article presents a real‑world case of optimizing a high‑concurrency transaction‑statistics API, detailing diagnosis of a 30‑second latency, SQL refactoring with array_agg and unnest, Java‑level improvements, and Caffeine caching, while also sharing promotional offers for ChatGPT services and a developer community.

CaffeineJavaPostgreSQL
0 likes · 13 min read
Optimizing a High-Concurrency Interface: Reducing Response Time from 30 s to 0.8 s with SQL Refactoring and Caffeine Caching
DaTaobao Tech
DaTaobao Tech
Jul 10, 2024 · Big Data

ODPS Development Guide: Parameters, Built‑in Functions, UDF Creation, and Performance Optimization

This comprehensive ODPS (MaxCompute) development guide serves as a mini‑encyclopedia, detailing common parameter tuning, built‑in SQL functions, step‑by‑step Java UDF creation, job lifecycle insights, and practical performance‑optimization techniques such as parallelism adjustment, map‑join hints, and small‑file mitigation.

MaxComputeODPSSQL
0 likes · 26 min read
ODPS Development Guide: Parameters, Built‑in Functions, UDF Creation, and Performance Optimization
Senior Tony
Senior Tony
Jul 10, 2024 · Databases

When to Use MySQL Hash Join vs. Nested Loop: A Practical Guide

This article explains MySQL's hash join algorithm, compares it with nested‑loop joins, shows how to read execution steps and EXPLAIN output, discusses extended hash‑join scenarios, and weighs the trade‑offs of performing multi‑table joins inside the database versus in application code.

Hash JoinJoin AlgorithmsMySQL
0 likes · 8 min read
When to Use MySQL Hash Join vs. Nested Loop: A Practical Guide
dbaplus Community
dbaplus Community
Jul 9, 2024 · Databases

Why MySQL LIMIT Can Kill Performance and How to Fix It

This article explains how the LIMIT clause can cause massive I/O and CPU overhead in MySQL queries, analyzes the underlying B+‑tree index structure and execution plans, and presents practical optimization techniques such as covering indexes, sub‑queries, and partitioning.

LIMITMySQLPerformance
0 likes · 9 min read
Why MySQL LIMIT Can Kill Performance and How to Fix It
DaTaobao Tech
DaTaobao Tech
Jul 8, 2024 · Big Data

ODPS (MaxCompute) SQL Basics, Data Integration and Hologres Import Guide

This guide provides a comprehensive, beginner‑to‑advanced reference for ODPS (MaxCompute) SQL, covering table creation, DDL/DML commands, query syntax, join hints, MySQL‑to‑ODPS synchronization, one‑click and custom imports into Hologres, and scheduling variables for automated data pipelines.

Data IntegrationETLHologres
0 likes · 37 min read
ODPS (MaxCompute) SQL Basics, Data Integration and Hologres Import Guide
Architecture Digest
Architecture Digest
Jul 8, 2024 · Backend Development

Introducing Easy-Query: A High‑Performance Java ORM with Fluent Query API

This article explains the motivation behind creating the Easy-Query ORM for Java, demonstrates its fluent query capabilities—including single‑record, list, pagination, joins, sub‑queries, group‑by, native SQL and dynamic condition features—provides extensive code examples, and shares repository links for further exploration.

DatabaseEasy-QueryJava
0 likes · 10 min read
Introducing Easy-Query: A High‑Performance Java ORM with Fluent Query API
DeWu Technology
DeWu Technology
Jul 5, 2024 · Databases

StarRocks 2.5.13 Cross-Cluster Upgrade and Data Migration Practices

The article outlines a cross‑cluster upgrade to StarRocks 2.5.13, evaluating resource and stability costs, and presents two migration schemes—using external tables and a Flink connector—along with planning, parallel execution, validation steps, and results showing successful migration of over 10 TB at 2 Gb/s across ten nodes, while noting future automation and CDC enhancements.

Data MigrationExternal TableFlink
0 likes · 15 min read
StarRocks 2.5.13 Cross-Cluster Upgrade and Data Migration Practices
Code Ape Tech Column
Code Ape Tech Column
Jul 5, 2024 · Databases

10 Essential Intermediate to Advanced SQL Concepts

This article presents ten crucial intermediate‑to‑advanced SQL concepts—including CTEs, recursive queries, temporary functions, CASE pivots, EXCEPT vs NOT IN, self‑joins, ranking functions, delta calculations, cumulative totals, and date‑time manipulation—each explained with clear examples and code snippets.

CTEData PivotRecursive Queries
0 likes · 11 min read
10 Essential Intermediate to Advanced SQL Concepts
Big Data Technology & Architecture
Big Data Technology & Architecture
Jul 3, 2024 · Databases

Optimizing High-Concurrency Point Queries in Doris with Row Store, Short Query Path, and PreparedStatement

This guide explains how to enable row store, configure short query path, and use PreparedStatement in Doris to reduce I/O and CPU overhead for high‑concurrency primary‑key point queries, including DDL examples, JDBC usage, row cache settings, performance tips, and verification methods.

DorisPreparedStatementRow Store
0 likes · 9 min read
Optimizing High-Concurrency Point Queries in Doris with Row Store, Short Query Path, and PreparedStatement
Java Tech Enthusiast
Java Tech Enthusiast
Jul 1, 2024 · Backend Development

MyBatis OGNL Comparison Pitfall: Single Character vs String

The article reveals that MyBatis’s OGNL treats a single‑character literal like '1' as a Character, causing equality checks against String values in if tags to fail, and shows how using double quotes, toString(), or proper type conversion resolves the comparison pitfall.

ComparisonDebuggingJava
0 likes · 4 min read
MyBatis OGNL Comparison Pitfall: Single Character vs String
ITPUB
ITPUB
Jun 30, 2024 · Databases

How Implicit Type Conversion Can Kill PostgreSQL Query Performance by 10,000×

This article explains how implicit type conversions in PostgreSQL can cause index loss, drastically misestimate row counts, and force inefficient join strategies, illustrating the issue with concrete examples, detailed execution plans, and step‑by‑step optimizations that restore index usage and boost performance thousands of times.

Implicit ConversionPerformance TuningPostgreSQL
0 likes · 13 min read
How Implicit Type Conversion Can Kill PostgreSQL Query Performance by 10,000×
Past Memory Big Data
Past Memory Big Data
Jun 27, 2024 · Big Data

Inside Presto 2.0: The Native C++ Query Engine Explained

This article provides a detailed technical overview of Presto 2.0, the native C++ query engine built on the Velox library, covering its motivation, vectorized architecture, memory management, performance benchmarks from Meta and IBM, and deployment practices for large‑scale data warehouses.

Big DataC++SQL
0 likes · 15 min read
Inside Presto 2.0: The Native C++ Query Engine Explained
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 27, 2024 · Databases

Evaluation of OceanBase Arbitration Service in a 2F1A Deployment: Fault Injection Experiments and Recovery Procedures

This article presents a detailed experimental study of OceanBase's Arbitration Service in a 2F1A (two full‑function replicas plus one arbitration node) configuration, examining how the system behaves when one or both full‑function replicas fail, how log‑stream degradation and permanent offline mechanisms work, and how normal service is restored after node recovery.

Arbitration ServiceOceanBaseRecovery
0 likes · 17 min read
Evaluation of OceanBase Arbitration Service in a 2F1A Deployment: Fault Injection Experiments and Recovery Procedures
Huolala Tech
Huolala Tech
Jun 25, 2024 · Big Data

How Huolala Built a Scalable Big Data Testing Platform to Cut Cycle Time by 70%

Huolala’s data testing platform tackles massive data volume, complexity, and quality challenges by automating test case generation, execution, monitoring, and alerting across multiple storage systems, dramatically reducing testing cycles from five days to 1.5 days and saving over 800 person-days.

SQLdata testingplatform architecture
0 likes · 19 min read
How Huolala Built a Scalable Big Data Testing Platform to Cut Cycle Time by 70%
IT Architects Alliance
IT Architects Alliance
Jun 23, 2024 · Databases

Configuring Druid DataSource Monitoring and Filters in Spring Boot

This guide explains the fundamentals of Druid as a Java database connection pool, how to add required Maven dependencies, configure various Druid properties and filters for SQL and web monitoring, enable slow‑SQL logging, integrate Spring AOP monitoring, remove the default Alibaba advertisement, and retrieve monitoring data via the DruidStatManagerFacade API.

Database MonitoringDruidJava
0 likes · 14 min read
Configuring Druid DataSource Monitoring and Filters in Spring Boot
Architect
Architect
Jun 22, 2024 · Backend Development

Master Druid: Configure, Monitor, and Optimize Spring Boot Data Sources

This guide explains how to integrate Alibaba's Druid connection pool into Spring Boot, covering basic concepts, Maven dependencies, essential configuration properties, built‑in filters, monitoring pages, SQL and slow‑query logging, Spring AOP monitoring, ad removal, and programmatic access to Druid statistics.

Database MonitoringDruidJava
0 likes · 16 min read
Master Druid: Configure, Monitor, and Optimize Spring Boot Data Sources
DataFunSummit
DataFunSummit
Jun 21, 2024 · Big Data

Building a Complete Data System with Apache Arrow: Architecture, Dynamic Schema Modeling, and Practical Tips

This article explains why new data systems are needed, introduces Apache Arrow and its columnar in‑memory format, describes dynamic read‑time modeling, outlines the system’s execution flow, storage and indexing strategies, and shares practical tips and extensions for building scalable big‑data solutions.

AceroApache ArrowBig Data
0 likes · 20 min read
Building a Complete Data System with Apache Arrow: Architecture, Dynamic Schema Modeling, and Practical Tips
DaTaobao Tech
DaTaobao Tech
Jun 21, 2024 · Big Data

Flink Real-Time Data Development: Cases on Data Skew, Watermark Failure, and GroupBy Issues

The article walks through three Flink streaming pitfalls—data‑skew‑induced back‑pressure, lost watermarks after interval joins, and ineffective group‑by causing duplicate rows—and shows how to resolve them with two‑stage distinct aggregation, hash‑based key distribution, processing‑time windows or split jobs, and mini‑batch buffering.

Data SkewFlinkOptimization
0 likes · 14 min read
Flink Real-Time Data Development: Cases on Data Skew, Watermark Failure, and GroupBy Issues
StarRocks
StarRocks
Jun 18, 2024 · Databases

How StarRocks Compaction Boosts Query Performance: Mechanics, Tuning, and Best Practices

This article explains StarRocks' compaction process that merges multiple data versions into larger files to reduce I/O, details the scheduler and executor roles, shows how to monitor and control compaction via SQL commands, and provides tuning parameters and best‑practice recommendations for optimal performance.

Data ManagementPerformance TuningSQL
0 likes · 21 min read
How StarRocks Compaction Boosts Query Performance: Mechanics, Tuning, and Best Practices
MaGe Linux Operations
MaGe Linux Operations
Jun 16, 2024 · Databases

Master MySQL Backups: Commands, Scripts, and Best Practices

This guide details how to use mysqldump and related commands to back up single or multiple MySQL databases, specific tables, compress backups, include drop statements, export only schema, and automate the process with scripts and cron jobs, plus instructions for restoring data.

MySQLSQLShell script
0 likes · 11 min read
Master MySQL Backups: Commands, Scripts, and Best Practices
Top Architect
Top Architect
Jun 16, 2024 · Databases

20 Essential SQL Optimization Techniques for Better Query Performance

This article presents twenty practical SQL optimization techniques—including index usage, selective column queries, avoiding functions in WHERE clauses, replacing subqueries with joins, limiting result sets, using prepared statements, proper data types, and transaction handling—to improve query performance and overall database efficiency.

Performance TuningQueriesSQL
0 likes · 11 min read
20 Essential SQL Optimization Techniques for Better Query Performance
21CTO
21CTO
Jun 14, 2024 · Databases

PostgreSQL vs MySQL: Which Database Wins for Full‑Stack Development?

An in‑depth comparison of PostgreSQL and MySQL covers their histories, ACID compliance, performance, scalability, advanced features, security, backup strategies, installation on Linux, and provides practical SQL code examples to help full‑stack developers choose the right open‑source relational database for their projects.

Database ComparisonLinuxMySQL
0 likes · 12 min read
PostgreSQL vs MySQL: Which Database Wins for Full‑Stack Development?
Architecture Digest
Architecture Digest
Jun 11, 2024 · Databases

Multi‑Branch Product Sales Statistics Query Using Row Comparison in MySQL

This article explains how to design a MySQL table for product sales statistics, initialize massive test data, and compare several query strategies—including loop queries, OR‑concatenated dynamic SQL, mixed filtering, and the SQL‑92 row‑comparison technique—to efficiently retrieve sales figures for multiple business units and their products without violating development constraints.

Dynamic SQLMySQLPerformance
0 likes · 7 min read
Multi‑Branch Product Sales Statistics Query Using Row Comparison in MySQL
Programmer XiaoFu
Programmer XiaoFu
Jun 11, 2024 · Databases

10 Advanced MySQL Query Techniques Every Data Engineer Should Know

This article presents ten essential advanced MySQL concepts—including CTEs, recursive CTEs, temporary functions, CASE‑WHEN pivots, EXCEPT vs NOT IN, self‑joins, ranking window functions, delta calculations, running totals, and date‑time manipulation—each explained with clear examples and practical SQL snippets.

CASE WHENCTEMySQL
0 likes · 11 min read
10 Advanced MySQL Query Techniques Every Data Engineer Should Know
Java Tech Enthusiast
Java Tech Enthusiast
Jun 10, 2024 · Databases

Common MySQL String Functions

MySQL offers a comprehensive set of string functions—including lower, upper, concat, substring/substr, length, char_length, instr, lpad, rpad, trim (with leading, trailing, both options), replace, repeat, reverse, and format—that enable case conversion, concatenation, extraction, padding, trimming, substitution, repetition, reversal, and numeric formatting of textual data.

DatabaseMySQLSQL
0 likes · 6 min read
Common MySQL String Functions
ITPUB
ITPUB
Jun 9, 2024 · Databases

Doris vs ClickHouse: Which Database Fits Your Workload?

This article compares Doris and ClickHouse across architecture, table creation, ecosystem integration, management tools, query performance, and join capabilities, offering practical guidance on how to choose the right database based on your specific data processing and operational requirements.

ClickHouseDatabase ComparisonDoris
0 likes · 10 min read
Doris vs ClickHouse: Which Database Fits Your Workload?