BestHub
Sign in
Tagged articles
2769 articles
Page 15 of 28
Top Architect
Top Architect
Mar 14, 2022 · Databases

Implementing Multi‑Business‑Unit Sales Queries with SQL Row‑Comparison in MySQL

This article explains how to design a MySQL table for product sales statistics and compares several query strategies—including loop queries, OR concatenation, mixed filtering, and the SQL‑92 row‑comparison technique—to efficiently retrieve sales data for multiple business units and their associated products in a single indexed query.

Database OptimizationDynamic SQLMyBatis
0 likes · 7 min read
Implementing Multi‑Business‑Unit Sales Queries with SQL Row‑Comparison in MySQL
ITPUB
ITPUB
Mar 10, 2022 · Databases

How to Speed Up Latest‑Record Queries in Large PostgreSQL Time‑Series Tables

This article explains why querying the most recent record for a specific device in massive time‑series tables can be painfully slow in PostgreSQL, demonstrates the impact of using only a timestamp index, and presents several indexing and query‑design strategies—including composite indexes, lateral joins, SkipScan, recursive CTEs, and logging tables with triggers—to dramatically improve performance.

Time-SeriesTimescaleDBTriggers
0 likes · 22 min read
How to Speed Up Latest‑Record Queries in Large PostgreSQL Time‑Series Tables
21CTO
21CTO
Mar 9, 2022 · Databases

Mastering Multi‑Business Sales Queries with Row‑Comparison in MySQL

This article explores how to query sales data for multiple business units and selected products in MySQL, comparing loop queries, OR concatenation, mixed filtering, and SQL‑92 row‑value comparison, ultimately recommending the row‑comparison technique for efficiency and maintainability.

Database designDynamic SQLRow Comparison
0 likes · 8 min read
Mastering Multi‑Business Sales Queries with Row‑Comparison in MySQL
Selected Java Interview Questions
Selected Java Interview Questions
Mar 8, 2022 · Databases

Understanding and Using CASE Expressions in SQL

This article explains the concept, syntax, and practical applications of SQL CASE expressions, covering simple and searched forms, row‑to‑column pivots, statistical transformations, conditional SELECT and UPDATE statements, and CHECK constraints, with detailed code examples and best‑practice tips.

CASE expressionConditional Logicdata transformation
0 likes · 14 min read
Understanding and Using CASE Expressions in SQL
DataFunTalk
DataFunTalk
Mar 8, 2022 · Databases

OpenMLDB 0.4.0 Full-Process Features and Quick‑Start Guide for Building End‑to‑End Online AI Applications

This article introduces the new full‑process features of OpenMLDB 0.4.0, explains its unified online/offline storage, high‑availability task management, and end‑to‑end AI workflow, and provides step‑by‑step instructions for quickly deploying both single‑node and cluster versions to run a complete online AI application.

AIWorkflowDistributedSystemsFeatureEngineering
0 likes · 24 min read
OpenMLDB 0.4.0 Full-Process Features and Quick‑Start Guide for Building End‑to‑End Online AI Applications
Top Architect
Top Architect
Mar 5, 2022 · Databases

Why MySQL LIMIT with Large Offsets Is Slow and How to Optimize It

The article demonstrates that MySQL queries using LIMIT with a large offset cause heavy random I/O by scanning many rows, and shows how rewriting the query with a sub‑query that selects only primary keys dramatically reduces execution time from seconds to milliseconds.

LIMITbuffer poolmysql
0 likes · 8 min read
Why MySQL LIMIT with Large Offsets Is Slow and How to Optimize It
DaTaobao Tech
DaTaobao Tech
Mar 3, 2022 · Databases

Comparative Analysis of MySQL and MongoDB: Features, Performance, and Practical Insights

The article compares MySQL’s relational tables with MongoDB’s schema‑free documents, detailing equivalent concepts, CRUD syntax, and benchmark results that show MongoDB achieving higher write and query throughput, easier schema evolution, and built‑in sharding, recommending it for new agile projects while suggesting MySQL remain viable for legacy systems.

MongoDBNoSQLPerformance Testing
0 likes · 14 min read
Comparative Analysis of MySQL and MongoDB: Features, Performance, and Practical Insights
IT Xianyu
IT Xianyu
Mar 3, 2022 · Databases

Introducing SPL: An Open‑Source Structured Data Processing Language with Full SQL‑92 Capabilities

SPL is an open‑source structured data processing language that extends full SQL‑92 functionality to a wide range of data sources—including CSV, Excel, JSON, NoSQL and Hadoop—allowing developers to perform complex queries, multi‑step calculations, and mixed‑source analytics without a traditional relational database.

Big DataData IntegrationSPL
0 likes · 14 min read
Introducing SPL: An Open‑Source Structured Data Processing Language with Full SQL‑92 Capabilities
Architect's Tech Stack
Architect's Tech Stack
Mar 3, 2022 · Databases

Understanding MySQL InnoDB Full-Text Search and Inverted Index

This article explains why traditional B‑Tree indexes fail for keyword searches, introduces the concept of inverted indexes, shows how to create and use MySQL InnoDB full‑text indexes with MATCH‑AGAINST in various modes, and covers index maintenance and query‑expansion techniques.

Boolean ModeFull‑Text Searchdatabase
0 likes · 12 min read
Understanding MySQL InnoDB Full-Text Search and Inverted Index
Programmer DD
Programmer DD
Mar 2, 2022 · Databases

Why DBeaver Is the Free Alternative to Navicat After the Malware Scare

Following the Navicat Premium malware incident, this guide introduces DBeaver—a free, open‑source, multi‑platform database management tool, explains its features, installation steps, driver setup, and where to obtain both community and commercial versions.

DBeaverDatabase ManagementJDBC
0 likes · 4 min read
Why DBeaver Is the Free Alternative to Navicat After the Malware Scare
Big Data Technology & Architecture
Big Data Technology & Architecture
Feb 23, 2022 · Big Data

Understanding Mini‑Batch Streaming Aggregation in Flink SQL

This article explains Flink SQL’s streaming aggregation Mini‑Batch feature, covering its purpose, configuration parameters, underlying optimizer rules, operator implementations, watermark handling, buffer processing, and the optional Local‑Global two‑phase aggregation optimization for improving throughput and reducing state overhead in large‑scale data pipelines.

Big DataFlinkMini-Batch
0 likes · 10 min read
Understanding Mini‑Batch Streaming Aggregation in Flink SQL
Youzan Coder
Youzan Coder
Feb 17, 2022 · Databases

Master MySQL Slow Query Optimization: Practical Indexing Techniques

This article shares hands‑on experience with MySQL 5.7 slow‑query problems, explaining common causes, proper index design, pitfalls that invalidate indexes, efficient SQL writing, deep‑pagination avoidance, and how to use EXPLAIN to verify that queries leverage the right indexes.

Database PerformanceExplain PlanIndex Optimization
0 likes · 16 min read
Master MySQL Slow Query Optimization: Practical Indexing Techniques
Laravel Tech Community
Laravel Tech Community
Feb 16, 2022 · Databases

Using Phinx for Database Migrations in ThinkPHP

This tutorial explains how to install, configure, and operate Phinx within a ThinkPHP project to manage database schema migrations, create and run seed data, update tables, roll back changes, and keep development environments synchronized.

CLIPHPPhinx
0 likes · 6 min read
Using Phinx for Database Migrations in ThinkPHP
Alibaba Cloud Developer
Alibaba Cloud Developer
Feb 14, 2022 · Backend Development

How Kuaishou Boosted Flink SQL Performance with Window Extensions and State Optimizations

Kuaishou dramatically increased Flink SQL adoption, introduced Group Window Aggregate and Window TVF extensions, applied aggregation state reuse and mini‑batch techniques, and enhanced stability through data‑skew mitigation and aggregate‑state compatibility, outlining future plans for streaming and batch SQL improvements.

FlinkState Optimizationsql
0 likes · 19 min read
How Kuaishou Boosted Flink SQL Performance with Window Extensions and State Optimizations
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Feb 14, 2022 · Backend Development

How MyBatis Parses and Applies Transaction Managers: A Deep Dive

This article walks through how MyBatis parses the transaction manager factory from XML configuration, builds the Environment, and applies the transaction manager during SqlSession creation, including detailed code examples of XMLConfigBuilder, transaction factories, and the JdbcTransaction implementation.

MyBatisbackend-developmentjava
0 likes · 8 min read
How MyBatis Parses and Applies Transaction Managers: A Deep Dive
Laravel Tech Community
Laravel Tech Community
Feb 13, 2022 · Databases

Understanding NULL Values and Their Impact on Indexes in MySQL

This article explains how MySQL treats NULL values, the behavior of IS NULL, IS NOT NULL, the spaceship operator, IFNULL, and demonstrates with practical examples how NULL affects indexing, query performance, aggregation functions, and sorting, while offering recommendations for schema design.

NULLindexesmysql
0 likes · 12 min read
Understanding NULL Values and Their Impact on Indexes in MySQL
dbaplus Community
dbaplus Community
Feb 13, 2022 · Databases

Mastering SQL Execution Order and Optimization: Practical Tips and Best Practices

This guide walks through MySQL's query execution sequence, then presents concrete optimization techniques—from selecting specific columns and avoiding OR conditions to proper indexing, using EXPLAIN, handling VARCHAR vs CHAR, limiting result sets, and improving joins, GROUP BY, and UNION operations—complete with code examples and visual explain plans.

databaseindexingmysql
0 likes · 20 min read
Mastering SQL Execution Order and Optimization: Practical Tips and Best Practices
Programmer DD
Programmer DD
Feb 13, 2022 · Backend Development

How SPL Transforms Report Data Preparation and Cuts Development Time

This article explains how the open‑source Structured Process Language (SPL) streamlines report data preparation, replaces complex SQL and Java code, supports multi‑source processing, enables hot‑swap, and dramatically reduces development effort and performance bottlenecks.

ReportingSPLdata preparation
0 likes · 16 min read
How SPL Transforms Report Data Preparation and Cuts Development Time
DaTaobao Tech
DaTaobao Tech
Feb 11, 2022 · Databases

Guidelines for Choosing Storage Solutions and Database Types

When selecting a storage engine, evaluate business metrics such as user and data volume, read/write bias, and consistency needs, then match those requirements to the strengths and limits of relational databases, key‑value caches, column‑stores, document stores, search engines, and other NoSQL options to achieve the right balance of performance, scalability, and operational cost.

NoSQLScalabilityperformance
0 likes · 17 min read
Guidelines for Choosing Storage Solutions and Database Types
Top Architect
Top Architect
Feb 11, 2022 · Databases

Understanding MySQL INT Display Width and ZEROFILL

This article explains that the numeric value in MySQL INT definitions (e.g., int(1) or int(10)) does not limit the column's range, demonstrates inserting the maximum unsigned value, and shows how ZEROFILL combined with a display width pads numbers with leading zeros.

ZEROFILLdisplay widthint
0 likes · 5 min read
Understanding MySQL INT Display Width and ZEROFILL
Laravel Tech Community
Laravel Tech Community
Feb 10, 2022 · Databases

Understanding MySQL INT Display Width and ZEROFILL Behavior

The article explains that the number in MySQL's INT definition (e.g., INT(1) or INT(4)) does not limit the column's numeric range, but only affects display width when combined with ZEROFILL, illustrating the concept with practical CREATE and INSERT examples.

Database designZEROFILLint
0 likes · 4 min read
Understanding MySQL INT Display Width and ZEROFILL Behavior
Architecture & Thinking
Architecture & Thinking
Feb 10, 2022 · Databases

MySQL Custom Functions: How to Create, Use, and Compare with Stored Procedures

This guide explains MySQL custom functions, covering their definition, advantages over stored procedures, step‑by‑step creation syntax, parameter handling, invocation, and management commands such as showing, altering, and dropping functions, with practical examples for both parameterless and parameterized functions and a concise comparison table.

Stored Proceduresfunctionsmysql
0 likes · 6 min read
MySQL Custom Functions: How to Create, Use, and Compare with Stored Procedures
dbaplus Community
dbaplus Community
Feb 6, 2022 · Databases

10 Common MySQL Index Pitfalls and How to Avoid Them

This article walks through ten typical scenarios where MySQL indexes fail—covering left‑most prefix violations, SELECT *, calculations, functions, type mismatches, LIKE patterns, column comparisons, OR, NOT IN/NOT EXISTS, and ORDER BY—showing why each occurs and how to keep indexes effective.

Index Optimizationcovering indexexplain
0 likes · 22 min read
10 Common MySQL Index Pitfalls and How to Avoid Them
Top Architect
Top Architect
Feb 6, 2022 · Databases

Understanding MySQL InnoDB Full‑Text Search and Inverted Index

This article explains why InnoDB full‑text search is needed for keyword‑based queries, introduces inverted index structures, shows how to create, use, and delete full‑text indexes in MySQL, and demonstrates natural language, boolean, and query‑expansion search modes with practical SQL examples.

Full‑Text Searchdatabaseinverted index
0 likes · 15 min read
Understanding MySQL InnoDB Full‑Text Search and Inverted Index
Youzan Coder
Youzan Coder
Jan 26, 2022 · Big Data

How to Build a Robust Data Quality Assurance Strategy for Large-Scale Data Platforms

This article outlines a comprehensive data quality assurance framework for a massive reporting platform, covering the data pipeline architecture, detailed testing methods for timeliness, completeness, and accuracy, as well as application‑level checks, downgrade and backup strategies, and future automation plans.

Data Qualityautomationbig data testing
0 likes · 14 min read
How to Build a Robust Data Quality Assurance Strategy for Large-Scale Data Platforms
Laravel Tech Community
Laravel Tech Community
Jan 25, 2022 · 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 differences with multiple SQL examples and visual illustrations of intermediate result tables.

LEFT JOINON clauseWHERE clause
0 likes · 5 min read
Understanding LEFT JOIN ON vs WHERE Conditions in SQL
Selected Java Interview Questions
Selected Java Interview Questions
Jan 21, 2022 · Databases

Performance Testing and Optimization of MySQL Pagination on Large Datasets

This article demonstrates how to generate, insert, and query ten‑million‑row MySQL tables, measures pagination query times under different offsets and limits, and presents practical optimization techniques such as sub‑queries, id‑range filtering, and column selection to improve performance on massive data sets.

databaselarge datasetsmysql
0 likes · 10 min read
Performance Testing and Optimization of MySQL Pagination on Large Datasets
IT Xianyu
IT Xianyu
Jan 19, 2022 · Databases

Understanding Linux Memory Usage, Buff/Cache Cleanup, and SQL Join Optimization

This article explains how to inspect and clear Linux memory buffers, details the information shown by the free command, and provides a comprehensive overview of SQL join types, their performance impact, and optimization techniques such as indexing, join buffer tuning, and algorithm choices.

BuffCacheDatabase PerformanceJOIN optimization
0 likes · 7 min read
Understanding Linux Memory Usage, Buff/Cache Cleanup, and SQL Join Optimization
Java Backend Technology
Java Backend Technology
Jan 18, 2022 · Databases

Master MySQL Full-Text Search: Inverted Indexes, Query Modes, and Optimization

This article explains how InnoDB implements full-text search using inverted indexes, shows how to create and use full-text indexes with various query modes—including natural language, boolean, and query expansion—covers relevance calculation, stopwords, token size limits, and demonstrates how to delete indexes, all illustrated with SQL examples and diagrams.

Boolean ModeFull‑Text Searchinverted index
0 likes · 13 min read
Master MySQL Full-Text Search: Inverted Indexes, Query Modes, and Optimization
Alimama Tech
Alimama Tech
Jan 12, 2022 · Artificial Intelligence

AI FAAS Solution for Advertising Tools: Architecture, Platform, and Real‑time Feature SQL Production

The team built a lightweight AI‑FAAS platform that migrates C++ ad‑algorithm services to a Java‑centric, cloud‑native environment, encapsulates core operators as DolphinSQL plugins, and defines real‑time feature pipelines via standardized SQL, cutting service creation from weeks to days, enabling rapid iteration, high operator reuse, and near‑instant feature delivery.

AIAdvertisingAlgorithm Platform
0 likes · 14 min read
AI FAAS Solution for Advertising Tools: Architecture, Platform, and Real‑time Feature SQL Production
Java Backend Technology
Java Backend Technology
Jan 11, 2022 · Databases

Why SQL Fails at Multi‑Group & Top‑N Queries and How SPL Fixes It

The article explains how conventional SQL struggles with executing multiple grouping and Top‑N aggregations on massive tables, leading to repeated full scans and poor performance, and demonstrates how the SPL compute engine can perform these operations in a single pass with parallelism, improving speed and scalability.

SPLbig-dataperformance
0 likes · 14 min read
Why SQL Fails at Multi‑Group & Top‑N Queries and How SPL Fixes It
macrozheng
macrozheng
Jan 11, 2022 · Big Data

Deploy Metabase in 5 Minutes and Master Its Data Visualization Features

Metabase is a fast, open‑source BI tool that can be set up in about five minutes using Docker, offering a user‑friendly interface for creating dashboards, custom SQL queries, data pivots, and multi‑table analysis without requiring deep SQL knowledge, making data visualization accessible to all.

BIData visualizationDocker
0 likes · 11 min read
Deploy Metabase in 5 Minutes and Master Its Data Visualization Features
Architects Research Society
Architects Research Society
Jan 8, 2022 · Databases

Understanding Database Isolation Levels and Dirty Reads

This article explains database isolation levels, including read committed, repeatable read, serializable, and snapshot isolation, discusses dirty reads, phantom reads, and how various systems such as SQL Server, PostgreSQL, MySQL, Oracle, MongoDB, and others implement or differ in these isolation semantics.

Isolation Leveldatabasedirty read
0 likes · 19 min read
Understanding Database Isolation Levels and Dirty Reads
dbaplus Community
dbaplus Community
Jan 5, 2022 · Big Data

How ByteDance Optimized Flink SQL for Real‑World Streaming at Scale

This article details ByteDance's practical experience with Apache Flink, covering SQL extensions, a visual SQL platform, performance tweaks such as window mini‑batching and custom windows, join and checkpoint recovery improvements, stream‑batch integration experiments, and future roadmap plans.

Batch IntegrationCheckpointFlink
0 likes · 16 min read
How ByteDance Optimized Flink SQL for Real‑World Streaming at Scale
Top Architect
Top Architect
Dec 25, 2021 · Databases

Using MySQL JSON Data Type for Flexible Schema Design and Efficient Indexing

This article explains the MySQL JSON data type, demonstrates how to store structured and semi‑structured data with JSON objects and arrays, shows practical table designs for user login and profiling, and details virtual columns, function indexes, and multi‑valued indexes for fast querying.

JSONMulti-Valued IndexVirtual Columns
0 likes · 13 min read
Using MySQL JSON Data Type for Flexible Schema Design and Efficient Indexing
Programmer DD
Programmer DD
Dec 25, 2021 · Databases

Why SQL Struggles with Complex Queries and How SPL Offers a Solution

The article analyzes four fundamental limitations of SQL—lack of stepwise execution, incomplete set semantics, missing ordered operations, and no object reference mechanism—illustrates them with real queries, and introduces SPL as a more intuitive language that overcomes these issues.

SPLdata analysisquery optimization
0 likes · 19 min read
Why SQL Struggles with Complex Queries and How SPL Offers a Solution
Laravel Tech Community
Laravel Tech Community
Dec 23, 2021 · Databases

Database Object Naming and Design Standards

This guide details comprehensive naming conventions and design best‑practices for MySQL database objects—including schemas, tables, indexes, views, stored procedures, functions, triggers, constraints, and users—along with recommended storage engine, character set, field types, index strategies, and SQL usage rules to ensure consistency, performance, and maintainability.

Naming Conventionindexingmysql
0 likes · 20 min read
Database Object Naming and Design Standards
Senior Brother's Insights
Senior Brother's Insights
Dec 21, 2021 · Databases

9 Essential MySQL Optimization Techniques to Boost Performance

This article presents practical MySQL optimization methods—including proper column definitions, NOT NULL usage, JOIN over sub‑queries, UNION, transaction handling, foreign keys, table locking, indexing strategies, and a collection of query‑tuning tips—each illustrated with clear examples and code snippets to improve database speed and reliability.

Database OptimizationTransactionsmysql
0 likes · 18 min read
9 Essential MySQL Optimization Techniques to Boost Performance
Alibaba Cloud Native
Alibaba Cloud Native
Dec 19, 2021 · Databases

Build a Serverless Order Storage System with Alibaba Cloud Tablestore

This article explains how to design and implement a fully elastic, zero‑ops Serverless database using Alibaba Cloud Tablestore, covering its architecture, key features, step‑by‑step CLI setup, table creation, data import, querying, indexing, and cost efficiency for high‑volume order workloads.

CLICloud NativeServerless
0 likes · 12 min read
Build a Serverless Order Storage System with Alibaba Cloud Tablestore
Big Data Technology & Architecture
Big Data Technology & Architecture
Dec 18, 2021 · Big Data

Slowly Changing Dimensions (SCD) – Design Principles, Challenges, and Hive Implementation

This article explains the concept of Slowly Changing Dimensions (SCD), discusses practical design questions, compares three change‑tracking requirements, presents three implementation patterns, and provides detailed Hive/SQL examples for historical data initialization and incremental updates in large‑scale data warehouses.

Big DataSCDdata-warehouse
0 likes · 20 min read
Slowly Changing Dimensions (SCD) – Design Principles, Challenges, and Hive Implementation
Youzan Coder
Youzan Coder
Dec 17, 2021 · Big Data

Upgrading Real-Time Computing Engine from Flink 1.10 to 1.13: Practices and Challenges

Youzan upgraded its real‑time computing engine from Flink 1.10 to 1.13 to meet rising SQL and containerization demands, gaining enhanced SQL syntax, time‑function handling, Window TVF standardization, Hive integration, K8s stability, elastic scaling, richer Kafka and format support, improved metrics and debugging tools, and successfully migrated all custom connectors, UDFs, and SQL jobs to the new Kubernetes‑based platform.

ContainerizationFlinkReal‑Time Computing
0 likes · 22 min read
Upgrading Real-Time Computing Engine from Flink 1.10 to 1.13: Practices and Challenges
dbaplus Community
dbaplus Community
Dec 12, 2021 · Databases

7 Common MySQL Index Pitfalls That Can Kill Query Performance

This article examines seven typical scenarios where MySQL indexes unexpectedly fail—such as OR conditions, leading wildcards in LIKE, missing quotes, functions on indexed columns, NULL checks, arithmetic operations, and composite index ordering—providing SQL examples, execution plans, and practical tips to avoid costly full‑table scans.

Database OptimizationQuery Tuningindex
0 likes · 9 min read
7 Common MySQL Index Pitfalls That Can Kill Query Performance
360 Tech Engineering
360 Tech Engineering
Dec 9, 2021 · Databases

Understanding MySQL Slow Query Analysis with EXPLAIN

This article explains why SQL queries can become slow, outlines MySQL's internal architecture, demonstrates how to use the EXPLAIN statement to view execution plans, and interprets key fields such as type, key, and Extra to help developers identify and optimize performance bottlenecks.

explainmysqlperformance
0 likes · 5 min read
Understanding MySQL Slow Query Analysis with EXPLAIN
Big Data Technology & Architecture
Big Data Technology & Architecture
Dec 8, 2021 · Big Data

Presto Overview, Architecture, and Query Optimization Techniques

This article introduces Presto, an open‑source MPP SQL engine, explains its coordinator‑worker architecture and connector model, and provides detailed storage, query, and join optimization strategies—including in‑memory parallelism, dynamic plan compilation, and practical SQL code examples—to achieve low‑latency, high‑performance analytics on big data.

Big DataPrestoquery optimization
0 likes · 7 min read
Presto Overview, Architecture, and Query Optimization Techniques
Java Interview Crash Guide
Java Interview Crash Guide
Dec 7, 2021 · Databases

Why Traditional Pagination Fails After Sharding and How to Solve It

When a table grows beyond ten million rows, sharding it across multiple databases improves performance, but the usual LIMIT offset, pagesize pagination breaks, leading to missing or incorrect records; this article examines why simple merge approaches fail and evaluates global, secondary query, and no‑skip paging strategies, highlighting their trade‑offs.

databasemysqlpagination
0 likes · 12 min read
Why Traditional Pagination Fails After Sharding and How to Solve It
Top Architect
Top Architect
Dec 4, 2021 · Databases

Optimizing MyBatis Batch Insert Performance with ExecutorType.BATCH and Foreach Limits

This article explains why MyBatis foreach batch inserts can become extremely slow when inserting thousands of rows, analyzes the underlying SQL and PreparedStatement overhead, and demonstrates how using ExecutorType.BATCH together with a limited batch size (20‑50 rows per statement) dramatically improves insertion speed.

Batch InsertDatabase PerformanceExecutorType.BATCH
0 likes · 9 min read
Optimizing MyBatis Batch Insert Performance with ExecutorType.BATCH and Foreach Limits
dbaplus Community
dbaplus Community
Nov 28, 2021 · Databases

Mastering MySQL Indexes: When to Use, Combine, and Optimize Them

This article explains why indexes are vital for MySQL performance, how to decide when to add ordinary, composite, prefix, or unique indexes, the pitfalls of using non‑sequential primary keys, and advanced optimizations such as change buffer, index condition pushdown, and MRR to reduce I/O.

B+TreeDatabase Optimizationindex
0 likes · 18 min read
Mastering MySQL Indexes: When to Use, Combine, and Optimize Them
dbaplus Community
dbaplus Community
Nov 27, 2021 · Big Data

How Vipshop’s Hera Data Service Boosts Big Data Access and Performance

The article details the design, architecture, core features, scheduling logic, and performance gains of Vipshop’s self‑built Hera data service, which unifies data‑warehouse access, supports multiple engines, adapts SQL execution, and dramatically improves SLA for both B‑to‑B and B‑to‑C workloads.

Big DataData ServiceETL
0 likes · 22 min read
How Vipshop’s Hera Data Service Boosts Big Data Access and Performance
macrozheng
macrozheng
Nov 26, 2021 · Databases

7 Common MySQL Index Pitfalls and How to Avoid Them

This article examines seven typical scenarios where MySQL indexes fail—such as OR conditions, leading wildcards, missing quotes, functions, NULL checks, arithmetic on indexed columns, and composite index order—explaining why they happen and offering practical solutions to maintain query performance.

Database Optimizationindexmysql
0 likes · 12 min read
7 Common MySQL Index Pitfalls and How to Avoid Them
macrozheng
macrozheng
Nov 23, 2021 · Databases

15 Essential SQL Optimization Tips to Boost Query Performance

This article presents fifteen practical SQL optimization techniques—including avoiding SELECT *, using UNION ALL, leveraging IN/EXISTS, batching inserts, applying LIMIT, controlling IN list size, incremental queries, efficient pagination, preferring JOINs, limiting join tables, managing indexes, choosing proper column types, improving GROUP BY, and using EXPLAIN—to help developers dramatically improve query speed and resource usage.

Query Tuningdatabaseindexing
0 likes · 20 min read
15 Essential SQL Optimization Tips to Boost Query Performance
dbaplus Community
dbaplus Community
Nov 21, 2021 · Databases

15 Proven SQL Optimization Techniques to Boost Query Performance

This article presents fifteen practical SQL optimization tips—including avoiding SELECT *, preferring UNION ALL, leveraging small‑table‑driven queries, batching inserts, applying LIMIT, handling large IN lists, incremental fetching, efficient pagination, join strategies, index management, field‑type choices, and using EXPLAIN—to dramatically improve MySQL query speed and resource usage.

databasemysqlperformance
0 likes · 18 min read
15 Proven SQL Optimization Techniques to Boost Query Performance
macrozheng
macrozheng
Nov 19, 2021 · Databases

Discover chiner: A Modern Open‑Source Database Design Tool

This article introduces chiner, an open‑source, cross‑platform database design tool built with React, Electron, and Java, compares it with PowerDesigner, walks through installation, core concepts, table and relationship management, and shows import/export capabilities for efficient schema development.

ElectronReactsql
0 likes · 8 min read
Discover chiner: A Modern Open‑Source Database Design Tool
Java Architect Essentials
Java Architect Essentials
Nov 14, 2021 · Backend Development

Comparative Implementation of Student Score Statistics Using Fluent Mybatis, Mybatis, and Mybatis‑Plus

This article demonstrates how to use Fluent Mybatis, native Mybatis, and Mybatis‑Plus to implement a complex student‑score aggregation query, compares their code structures, generation settings, and highlights the advantages and drawbacks of each approach for backend development.

Fluent MyBatisORMbackend-development
0 likes · 9 min read
Comparative Implementation of Student Score Statistics Using Fluent Mybatis, Mybatis, and Mybatis‑Plus
dbaplus Community
dbaplus Community
Nov 14, 2021 · Databases

What Happens When MySQL DROP Permission Is Revoked? A Hands‑On Exploration

After a colleague accidentally dropped a production database, we revoked DROP privileges for a MySQL user and systematically tested how this restriction impacts common operations such as renaming tables, using TRUNCATE, deleting rows, dropping objects, and recovering data via binlog, revealing surprising behaviors and practical workarounds.

DROP permissionTRUNCATEbinlog recovery
0 likes · 9 min read
What Happens When MySQL DROP Permission Is Revoked? A Hands‑On Exploration
Top Architect
Top Architect
Nov 11, 2021 · Databases

How to Remove Duplicate Data in MySQL Tables Efficiently

This article explains why duplicate rows appear in MySQL tables, demonstrates how to identify them with SELECT queries, and provides step‑by‑step SQL solutions—including safe deletion of all duplicates or retaining a single record per group—using subqueries and temporary tables for efficient cleanup.

Duplicate Datadata deduplicationdatabase cleanup
0 likes · 5 min read
How to Remove Duplicate Data in MySQL Tables Efficiently
Su San Talks Tech
Su San Talks Tech
Nov 10, 2021 · Databases

15 Proven SQL Optimization Techniques to Boost Query Performance

This article presents fifteen practical SQL optimization tips—including avoiding SELECT *, using UNION ALL, driving large tables with small ones, batch operations, LIMIT usage, index control, proper data types, and efficient GROUP BY—to help developers improve query speed, reduce resource consumption, and avoid common performance pitfalls.

Query Tuningdatabaseindexing
0 likes · 20 min read
15 Proven SQL Optimization Techniques to Boost Query Performance
Top Architect
Top Architect
Nov 9, 2021 · Databases

Understanding MySQL Indexes: Types, Structures, and Usage

This article explains MySQL index fundamentals, classifies indexes by data structure, storage engine, field characteristics and column count, compares B+Tree with B‑Tree, hash and red‑black trees, and demonstrates practical creation, usage, and optimization techniques with SQL examples and diagrams.

B+TreeInnoDBindex
0 likes · 14 min read
Understanding MySQL Indexes: Types, Structures, and Usage
Architect's Tech Stack
Architect's Tech Stack
Nov 9, 2021 · Backend Development

Comparative Implementation of a Student Score Statistics Query Using Fluent MyBatis, Native MyBatis, and MyBatis‑Plus

This article demonstrates how to implement a student score statistics query—calculating count, minimum, maximum, and average scores per term and subject—using Fluent MyBatis, native MyBatis, and MyBatis‑Plus, comparing code complexity, configuration, and generated code across the three approaches.

Fluent MyBatisMyBatisMyBatis-Plus
0 likes · 9 min read
Comparative Implementation of a Student Score Statistics Query Using Fluent MyBatis, Native MyBatis, and MyBatis‑Plus
Ops Development Stories
Ops Development Stories
Nov 9, 2021 · Databases

Master MySQL Index Optimization: 10 Practical Tips to Avoid Index Pitfalls

This article demonstrates how to create and use a sample employees table, explains composite index structures, and provides ten concrete MySQL index best‑practice guidelines—covering full‑value matches, leftmost‑prefix rules, avoiding functions, range conditions, covering indexes, inequality, NULL checks, leading wildcards, type conversions, and OR usage—each illustrated with EXPLAIN output and code examples.

Database PerformanceIndex Optimizationcovering index
0 likes · 10 min read
Master MySQL Index Optimization: 10 Practical Tips to Avoid Index Pitfalls
ITPUB
ITPUB
Nov 8, 2021 · Databases

When a Missing Index Cost $5,000: Lessons from a PlanetScale Mishap

An engineer’s oversight in a PlanetScale schema—omitting a foreign‑key‑based index—led to massive row‑scan costs, prompting a $5,000 bill, while the article also critiques junior developers’ naive schema designs and offers advice on proper database indexing and mentorship.

Junior DevelopersPlanetScalesql
0 likes · 8 min read
When a Missing Index Cost $5,000: Lessons from a PlanetScale Mishap
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Nov 7, 2021 · Backend Development

Comprehensive Overview and Source Code Analysis of the MyBatis Persistence Framework

This article provides a detailed introduction to MyBatis, covering its relationship with JDBC, core components, execution flow, configuration, design patterns, caching strategies, plugin mechanisms, logging options, dynamic SQL features, and includes complete Java and XML code examples to illustrate practical usage.

BackendDesign PatternsMyBatis
0 likes · 19 min read
Comprehensive Overview and Source Code Analysis of the MyBatis Persistence Framework