Tagged articles
UNSIGNED INT
12 articles · Page 1 of 1
The article explains that storing IPv4 addresses as a 32‑bit UNSIGNED INT in MySQL reduces storage and index size, speeds up range queries, and provides built‑in conversion functions, while also noting readability drawbacks and offering Java conversion examples.
ConversionINET_ATONIP address
0 likes · 5 min read

The article explains that using a 32‑bit UNSIGNED INT to store IPv4 addresses in MySQL saves space and improves index and range‑query performance, outlines the storage savings compared to VARCHAR, mentions the need for manual conversion, and provides MySQL and Java code examples for converting between string and integer representations.
Data StorageIPv4MySQL
0 likes · 5 min read

The article explains that storing IPv4 addresses as a 32‑bit UNSIGNED INT in MySQL saves storage and index space, enables faster range queries, outlines conversion functions like INET_ATON/INET_NTOA, discusses drawbacks such as readability, and provides Java utilities for IP‑long transformations.
Database DesignIP ConversionIPv4
0 likes · 6 min read

Storing IPv4 addresses as a 32‑bit UNSIGNED INT instead of VARCHAR saves storage space, reduces index size, enables faster range queries, and leverages MySQL’s built‑in INET_ATON/INET_NTOA functions, while the trade‑offs include reduced readability and the need for conversion code, as demonstrated with benchmarks and Java examples.
INET_ATONIP address storageJava
0 likes · 5 min read

This article explains why using a 32‑bit UNSIGNED INT to store IPv4 addresses in MySQL saves space and improves query performance, outlines the trade‑offs such as readability, shows MySQL conversion functions, discusses IPv6 alternatives, and provides Java code for converting between string and numeric representations.
Database PerformanceIP addressJava
0 likes · 5 min read

The article explains that using a 32‑bit UNSIGNED INT to store IPv4 addresses in MySQL saves space and improves indexing and range queries, outlines the conversion functions and their performance, discusses readability drawbacks, and provides Java code for bidirectional conversion between string and integer representations.
Data StorageIP addressJava
0 likes · 6 min read

This article explains the theoretical and practical range of Tencent QQ numbers, why the lower limit is set to 10001, how unused accounts are reclaimed, and demonstrates how bitmap techniques can efficiently deduplicate billions of QQ IDs using simple C++ code.
AlgorithmBitmapC++
0 likes · 8 min read

The article explains that using a 32‑bit UNSIGNED INT to store IPv4 addresses in MySQL saves space, improves index and range‑query performance, and provides built‑in conversion functions, while also noting readability drawbacks and offering Java utilities for manual conversion.
INET_ATONIP address storageJava
0 likes · 6 min read

The article explains why MySQL recommends storing IPv4 addresses as a 32‑bit UNSIGNED INT instead of strings, outlines space and query advantages, notes readability drawbacks, and demonstrates conversion using built‑in functions and Java utility code.
Database DesignINET_ATONIP address
0 likes · 6 min read

The article explains why storing IPv4 addresses as a 32‑bit unsigned integer in MySQL saves space and improves range‑query performance, outlines the trade‑offs such as readability, and demonstrates conversion using MySQL functions and Java code examples.
INET_ATONIPv4MySQL
0 likes · 5 min read

This article explains why storing IPv4 addresses as UNSIGNED INT in MySQL saves space and improves query performance, outlines the pros and cons, shows built‑in conversion functions, and provides Java code for converting between string and numeric representations.
Database DesignINET_ATONIPv4
0 likes · 5 min read

Storing IPv4 addresses as a 32‑bit UNSIGNED INT in MySQL saves space, enables faster range queries, and leverages built‑in conversion functions like INET_ATON/INET_NTOA, while requiring manual readability handling, and can be complemented by Java utilities for application‑level conversions.
INET_ATONIPv4Java
0 likes · 5 min read
