BestHub
Sign in
Tagged articles
39 articles
Page 1 of 1
java1234
java1234
Jan 27, 2026 · Backend Development

7 Proven Spring Boot Startup Hacks to Slash Over 70% of Boot Time

This article presents seven concrete Spring Boot startup optimization techniques—including lazy bean initialization, precise component scanning, JVM flag tuning, auto‑configuration pruning, class‑loading shortcuts, lazy database connections, and GraalVM native compilation—backed by real‑world benchmarks that reduce launch times by up to 71% across e‑commerce, micro‑service, logistics and payment services.

Database ConnectionSpring Bootauto-configuration
0 likes · 9 min read
7 Proven Spring Boot Startup Hacks to Slash Over 70% of Boot Time
Liangxu Linux
Liangxu Linux
Nov 25, 2025 · Databases

Why a Single MySQL Connection Can Take 200 ms – A Wireshark Deep Dive

This article measures the exact time cost of establishing a MySQL connection from Java, breaks down the TCP handshake, authentication, and protocol steps with Wireshark captures, and shows why connection pooling is essential for high‑traffic web applications.

Connection PoolingDatabase ConnectionWireshark
0 likes · 8 min read
Why a Single MySQL Connection Can Take 200 ms – A Wireshark Deep Dive
Java Backend Technology
Java Backend Technology
Nov 17, 2025 · Databases

Why a Single MySQL Connection Can Cost Over 200 ms – A Deep Dive

This article examines the detailed steps and timing of establishing a MySQL connection from a Java web application, measuring network round‑trips and total latency, and demonstrates how even a minimal connection can consume hundreds of milliseconds, making connection pooling essential for high‑traffic services.

Connection PoolDatabase ConnectionTCP
0 likes · 8 min read
Why a Single MySQL Connection Can Cost Over 200 ms – A Deep Dive
php Courses
php Courses
Oct 27, 2025 · Backend Development

Master PHP Database Connections: MySQLi and PDO Step‑by‑Step Guide

Learn how to establish, use, and close MySQL database connections in PHP with detailed MySQLi and PDO examples, covering object‑oriented syntax, prepared statements, error handling, and best practices for secure and efficient backend development.

Database ConnectionMySQLiPDO
0 likes · 4 min read
Master PHP Database Connections: MySQLi and PDO Step‑by‑Step Guide
Architecture Digest
Architecture Digest
Jul 3, 2025 · Backend Development

How to Implement Efficient MyBatis Streaming Queries in Spring Boot

This article explains what streaming queries are, why MyBatis's Cursor requires an open database connection, and presents three practical solutions—using SqlSessionFactory, TransactionTemplate, or @Transactional—to correctly implement MyBatis streaming queries in Spring applications while avoiding common pitfalls.

CursorDatabase ConnectionMyBatis
0 likes · 6 min read
How to Implement Efficient MyBatis Streaming Queries in Spring Boot
Programmer DD
Programmer DD
Jun 4, 2025 · Backend Development

How a Spring Boot Upgrade Cut Our AWS Bill by 45%

Facing a soaring AWS bill despite stable traffic, we traced the cost to over‑provisioned EC2 instances and leaking database connections, then upgraded to Spring Boot 3.5 and applied targeted pool, transaction, and JPA tweaks, achieving a 45% reduction in monthly spend while boosting performance and reliability.

Database Connectionaws-cost-optimizationperformance-tuning
0 likes · 16 min read
How a Spring Boot Upgrade Cut Our AWS Bill by 45%
Architect's Guide
Architect's Guide
Apr 6, 2025 · Databases

Analyzing MySQL Connection Latency in Java Applications

This article investigates the time cost of establishing and closing MySQL connections in Java web applications, using Wireshark packet captures and code examples to demonstrate that a single connection can take over 200 ms, highlighting the importance of connection pooling and performance optimizations.

Connection PoolingDatabase ConnectionWireshark
0 likes · 7 min read
Analyzing MySQL Connection Latency in Java Applications
Architect's Guide
Architect's Guide
Feb 12, 2025 · Databases

Analyzing MySQL Database Connection Latency in Java Applications

This article investigates the time cost of establishing and closing a MySQL connection from a Java web application, using Wireshark packet captures and simple code examples to quantify latency and illustrate why connection pooling is essential for high‑traffic services.

Connection PoolingDatabase Connectionjava
0 likes · 7 min read
Analyzing MySQL Database Connection Latency in Java Applications
Top Architecture Tech Stack
Top Architecture Tech Stack
Jan 14, 2025 · Databases

Analyzing MySQL Connection Latency in Java Web Applications

This article investigates the detailed steps and time consumption of establishing and closing a MySQL connection from a Java web application, using Wireshark packet captures and code examples to demonstrate why connection pooling is essential for high‑traffic services.

Connection PoolingDatabase ConnectionWireshark
0 likes · 7 min read
Analyzing MySQL Connection Latency in Java Web Applications
Java Backend Technology
Java Backend Technology
Nov 15, 2024 · Databases

How a MySQL Connection Takes 200ms+ and Why You Need a Pool

This article dissects the MySQL connection process using Java and Wireshark, revealing that establishing a single connection can consume over 200 ms, which scales to hours of latency for high‑traffic sites, highlighting the necessity of connection pooling and related optimizations.

Connection PoolDatabase ConnectionWireshark
0 likes · 7 min read
How a MySQL Connection Takes 200ms+ and Why You Need a Pool
php Courses
php Courses
Apr 24, 2024 · Backend Development

How to Connect to a Database Using PHP

This tutorial explains how to connect PHP to databases using both mysqli and PDO, covering connection setup, error handling, executing queries, and properly closing the connection, with complete code examples for each method.

Database ConnectionMySQLiPDO
0 likes · 4 min read
How to Connect to a Database Using PHP
Java Captain
Java Captain
Mar 28, 2024 · Databases

Analyzing the Cost of Establishing MySQL Database Connections in Java Applications

This article investigates the time overhead of establishing MySQL database connections in Java web applications, detailing the TCP handshake, authentication steps, and measured latency using Wireshark, and demonstrates why connection pooling is essential to avoid hundreds of milliseconds per request.

Connection PoolingDatabase ConnectionWireshark
0 likes · 7 min read
Analyzing the Cost of Establishing MySQL Database Connections in Java Applications
MaGe Linux Operations
MaGe Linux Operations
Jan 7, 2024 · Backend Development

Mastering MySQL Connections in Go: From Raw SQL to GORM ORM

Learn how to connect Go applications to MySQL using the native driver and the GORM ORM, covering driver installation, basic connection code, database configuration, query execution, and best practices for model definition and handling common pitfalls.

Database ConnectionGORMORM
0 likes · 9 min read
Mastering MySQL Connections in Go: From Raw SQL to GORM ORM
Code Ape Tech Column
Code Ape Tech Column
Nov 28, 2022 · Backend Development

Resolving Long Transactions and Connection‑Closed Issues in Spring with Druid

This article analyzes why a Spring service encounters "connection closed" errors during long‑running transactions, explains how MyBatis and Druid manage connections, and provides a programmatic‑transaction solution that splits large operations into smaller units to prevent connection leaks and timeouts.

Database ConnectionDruidLong Transaction
0 likes · 11 min read
Resolving Long Transactions and Connection‑Closed Issues in Spring with Druid
IT Architects Alliance
IT Architects Alliance
Aug 8, 2022 · Backend Development

Why Object Pools Boost Java Performance: Deep Dive into Commons Pool 2 and HikariCP

This article explains the motivation behind object pooling in Java, walks through the core classes of Commons Pool 2 with a Jedis example, details key configuration parameters, presents JMH benchmark results that show a five‑fold throughput gain, and analyzes HikariCP’s design tricks and common interview questions about pool tuning.

Commons Pool 2Database ConnectionHikariCP
0 likes · 16 min read
Why Object Pools Boost Java Performance: Deep Dive into Commons Pool 2 and HikariCP
Architect
Architect
Aug 5, 2022 · Databases

Understanding Object Pooling in Java: Commons Pool 2, HikariCP, and Performance Benchmarks

This article explains Java object pooling concepts, introduces the Commons Pool 2 library and its usage with Redis's Jedis client, compares it with the high‑performance HikariCP database connection pool, and presents JMH benchmark results demonstrating significant throughput gains, while also covering configuration parameters and interview questions.

Commons-PoolDatabase ConnectionHikariCP
0 likes · 15 min read
Understanding Object Pooling in Java: Commons Pool 2, HikariCP, and Performance Benchmarks
Baidu Intelligent Cloud Tech Hub
Baidu Intelligent Cloud Tech Hub
Jul 7, 2022 · Backend Development

How to Build APIs, FaaS Functions, and Direct DB Connections in Baidu’s Low‑Code Platform

This article explains how Baidu Intelligent Cloud’s low‑code platform “AiSuDa” enables developers to create API orchestration flows, integrate Function‑as‑a‑Service nodes, and connect directly to external or built‑in databases, providing a no‑code alternative to traditional backend development for data‑driven applications.

API orchestrationDatabase ConnectionFaaS
0 likes · 19 min read
How to Build APIs, FaaS Functions, and Direct DB Connections in Baidu’s Low‑Code Platform
Top Architect
Top Architect
Jul 1, 2022 · Databases

Analyzing the Time Cost of Establishing MySQL Database Connections in Java Web Applications

This article examines how a MySQL connection is created from a Java web application, breaking down the TCP handshake, authentication, and variable‑setting steps with Wireshark captures, measuring latency, and demonstrating why connection pooling is essential to avoid hundreds of milliseconds of overhead per request.

Connection PoolDatabase ConnectionTCP
0 likes · 7 min read
Analyzing the Time Cost of Establishing MySQL Database Connections in Java Web Applications
Top Architect
Top Architect
Apr 14, 2022 · Databases

Analyzing the Cost of Establishing MySQL Database Connections in Java

This article investigates how much time a simple Java program spends establishing and closing a MySQL connection, measures the latency of each TCP and MySQL handshake step with Wireshark, and demonstrates why connection pooling is essential for high‑traffic web services.

Connection PoolingDatabase Connectionjava
0 likes · 8 min read
Analyzing the Cost of Establishing MySQL Database Connections in Java
php Courses
php Courses
Mar 9, 2021 · Databases

Troubleshooting PHP PDO MySQL Connection Issues on Windows

This guide explains how to enable the PDO extension, configure php.ini, write connection code with proper error handling, and debug SQL statement errors to resolve common MySQL connection problems in PHP on Windows environments.

Database ConnectionWindowsmysql
0 likes · 3 min read
Troubleshooting PHP PDO MySQL Connection Issues on Windows
Top Architect
Top Architect
Jan 27, 2021 · Databases

MyBatis Streaming Query (Cursor) – Keeping the Database Connection Open

This article explains what a streaming query is, introduces MyBatis's Cursor interface and its methods, demonstrates common pitfalls such as the cursor being closed prematurely, and provides three practical solutions using SqlSessionFactory, TransactionTemplate, and @Transactional to keep the database connection alive during streaming reads.

CursorDatabase ConnectionMyBatis
0 likes · 7 min read
MyBatis Streaming Query (Cursor) – Keeping the Database Connection Open
Mafengwo Technology
Mafengwo Technology
Nov 28, 2019 · Backend Development

From PHP to Java: My Journey Refactoring E‑Commerce with Spring Boot

The author, a former PHP engineer at Mafengwo, chronicles a two‑day crash‑course in Java and Spring Boot, detailing the adoption of Lombok, Druid, Maven, and various annotations while navigating pitfalls such as bean scopes, database connections, and data format mismatches before successfully launching the new service.

Database ConnectionLombokSpring Boot
0 likes · 13 min read
From PHP to Java: My Journey Refactoring E‑Commerce with Spring Boot
DevOps Cloud Academy
DevOps Cloud Academy
Sep 25, 2019 · Databases

How to Connect MySQL and Oracle Databases with JMeter

This guide walks through configuring JMeter to connect to MySQL and Oracle databases via JDBC, covering driver installation, JMeter component setup, request creation, result verification, and troubleshooting common connection errors for performance testing.

Database ConnectionJDBCJMeter
0 likes · 4 min read
How to Connect MySQL and Oracle Databases with JMeter
ITPUB
ITPUB
Jun 13, 2016 · Databases

How to Connect to Oracle When Your Password Contains an @ Symbol

When an Oracle user password includes the '@' character, standard sqlplus login fails with a connection string parsing error; escaping the '@' by using backslashes or enclosing the password in double quotes restores successful connection.

Database ConnectionEscape CharacterOracle
0 likes · 3 min read
How to Connect to Oracle When Your Password Contains an @ Symbol