This article explains how to build a high‑performance data‑lake analytics stack by combining StarRocks with Apache Paimon, covering direct queries, Data Cache acceleration, and asynchronous materialized views, and presents benchmark results that show StarRocks achieving up to 4.3× faster query speeds than Trino and significant latency reductions with caching and materialized views.
MetaApp replaced ClickHouse with the open‑source cloud‑native warehouse ByConity, achieving more than 50% reduction in resource costs while delivering comparable or faster OLAP query performance across distinct, retention, conversion, and point‑lookup workloads, thanks to compute‑storage separation, read/write isolation, and minute‑level elastic scaling.
This article introduces MySQL and PostgreSQL, compares their architectures and benchmark results, highlights performance differences in SELECT, INSERT, and UPDATE operations, and discusses suitable scenarios and trade‑offs to help developers choose the appropriate database for their applications.
The article introduces MySQL and PostgreSQL, compares their performance through a benchmark on identical hardware, discusses each system’s strengths, weaknesses, and suitable application scenarios, and provides guidance on choosing the appropriate database for different workloads.
The author tests Moonshot’s Kimi API, revealing its 200 k‑character context window, superior token‑to‑character ratio compared with GPT‑3.5 and Gemini, and performance that, while slower than GPT‑3.5 Turbo, rivals GPT‑4 Turbo, all while offering OpenAI‑compatible endpoints and free credit for developers.
cyeva is an open‑source Python library that automates deterministic weather forecast accuracy assessment, offering built‑in metrics for temperature, precipitation, wind and other continuous variables, with installation via pip or conda, performance benchmarks, and community‑driven extensions.
An extensive benchmark compares MySQL 8.2 Community and Enterprise editions using sysbench and TPC‑C on identical EC2 instances, revealing that, under default configurations, the Enterprise edition offers no consistent performance advantage over the Community edition, with only occasional gains from optional plugins.
Community vs EnterpriseDatabase ConfigurationTPC-C
An in‑depth comparison of MySQL and PostgreSQL covers their histories, architectural differences, benchmark results showing PostgreSQL’s superior SELECT, INSERT, and UPDATE throughput, and guidance on selecting the appropriate database based on application complexity, scale, and performance requirements.
The article explains why traditional MySQL sharding is problematic, introduces the open‑source distributed database TiDB, details its architecture, core features, use cases, performance benchmarks against MySQL, and provides guidance on when to adopt TiDB for large‑scale workloads.
This guide shows how to deploy a cost‑effective, secure Stable Diffusion XL Turbo text‑to‑image service on an Alibaba Cloud ACK cluster using CPU‑only instances, Helm charts, and optional confidential TDX VM pools for protected inference.
This article compares JDK 8, 17, and 21 using SPECjbb®2015 to evaluate throughput, latency, and memory consumption of G1, Parallel, and generational ZGC, highlighting significant performance gains and offering upgrade guidance for Java applications.
RediSearch, a low‑memory Redis module, offers comparable full‑text search capabilities to Elasticsearch, with faster indexing and query performance on modest hardware; this article explains its features, compares benchmarks, shows Docker installation, and provides Java/Jedis code examples for creating, querying, and managing indexes.
This article provides a comprehensive overview and comparative analysis of popular Java expression engines—including AviatorScript, MVEL, OGNL, SpEL, QLExpress, JEXL, JUEL, and Janino—covering their features, community support, size, performance benchmarks, security settings, usage cases, and syntax differences to guide developers in selecting the most suitable engine for their projects.
The article traces the shift from traditional Hive‑based warehouses to modern lakehouse architectures, explains the advantages of lake formats, introduces Apache Paimon as a streaming‑first data lake integrated with Flink, presents performance benchmarks showing its superiority over Hudi, and demonstrates a real‑time streaming lakehouse workflow.
This article details a Chinese tech company's migration of its internal big‑data analytics platform to StarRocks’ compute‑storage separation architecture, describing the original multi‑component setup, the pain points encountered, the evaluation methodology, performance and cost benchmarks, operational optimizations, migration steps, and future roadmap.
The article analyzes DeWu’s product lifecycle, explains New, Product, and Draft types, introduces state‑machine fundamentals, compares Java enum, Spring, Squirrel, and Cola implementations, benchmarks their throughput (showing Cola vastly faster), and concludes that despite Cola’s performance, Spring StateMachine is chosen for its richer features and seamless Spring integration.
This article explains why master‑slave lag occurs in MySQL, describes the evolution of parallel replication schemes—including group‑commit, Commit‑Parent‑Based, Lock‑Based, and WRITESET approaches—shows benchmark results, and provides practical configuration steps to enable high‑performance parallel replication.
After upgrading a Doris cluster from version 1.2.3 to 2.0.2, the author runs a series of SQL benchmarks—including PK lookups, top‑client queries, distinct counts on low‑ and high‑cardinality columns, minute‑level session analysis, and full‑table deduplication—to measure execution times, revealing mixed performance gains and regressions across the seven test scenarios.
tRPC is an open‑source, plugin‑based RPC framework that separates core communication, service‑governance, and invocation layers, supports extensible codecs, naming, config, metrics, logging and tracing plugins, offers an Admin API, and demonstrates high throughput and low tail latency in cloud‑native deployments.
This article explains how CPU core count, clock speed, and cache, as well as GPU shader count, frequency, memory bandwidth, and graphics‑card memory size and interface affect performance, and shows 2023 desktop and laptop performance ladder charts to help users compare and choose the right hardware.
This article introduces Dragonfly, an open‑source in‑memory database compatible with Redis and Memcached APIs, explains its architectural innovations, presents benchmark code comparing it with Redis, and discusses real‑world performance results and future development plans.
This article details Taikang Life's end‑to‑end design and implementation of a lakehouse‑style distributed data platform built on Apache Hudi, covering background, technical selection, architecture, custom Hudi extensions for the health insurance domain, performance benchmarks, real‑world results, and future work.
A comprehensive benchmark shows RedisJSON (RediSearch) dramatically outperforms MongoDB and ElasticSearch in isolated writes, isolated reads, mixed workloads, and latency, delivering up to 200‑plus times faster writes, over 500‑times faster reads, and significantly lower latency across all operation types.
This article summarizes a performance comparison between Spring Boot applications using virtual threads and those built with Spring WebFlux, detailing the test scenario of JWT verification and MySQL queries, the environment, code implementations, benchmark results across various concurrency levels, and concluding that WebFlux outperforms virtual‑threaded Spring Boot.
The article examines Modular's new Mojo language, its claim of massive performance gains over Python for AI workloads, presents benchmark code and results, discusses its origins, investment interest, and current beta status, concluding that while impressive, the 36,000× claim is overstated.
This article explains the key performance metrics of CPUs, GPUs, and graphics cards, shows how ladder charts are built from benchmark data, and provides practical tips for choosing the right hardware for desktops and laptops based on these rankings.
This article presents a detailed benchmark comparing Redpanda 23.1 and Apache Kafka 3.4.0 (with and without KRaft) across multiple AWS instance types, showing how Redpanda consistently delivers higher throughput and dramatically lower end‑to‑end latency, often outperforming Kafka by 4‑20× even with extra hardware.
This guide explains how to deploy large language models on Alibaba Cloud's ACK using KServe for serverless inference, integrates Fluid for distributed data caching to cut cold‑start latency, provides step‑by‑step commands, performance benchmarks, and practical tips for production‑grade AI model serving.
Using the TPC‑DS benchmark’s 99 queries on a 1 TB dataset, this study evaluates the performance of four open‑source OLAP engines—ClickHouse, Doris, Presto, and ByConity—across basic, join, aggregation, subquery, and window‑function scenarios, revealing ByConity’s superior speed and the limitations of ClickHouse.
This article compares Elasticsearch and ClickHouse as log‑analytics solutions, detailing their architectures, node roles, data ingestion pipelines, query capabilities, and benchmark results, ultimately showing ClickHouse’s superior performance in most tested scenarios.
The article analyzes how leading vendors such as Google, Intel, IBM, Samsung, Nvidia and AMD are racing to develop AI ASICs, compares their architectures and performance, and projects a rapid rise in ASIC market share for both data‑center and edge AI workloads by 2025.
This article examines China’s domestic CPU market, profiling six manufacturers, comparing their architectures (ARM, x86, LoongArch, RISC‑V, Alpha), detailing technical specifications, performance benchmarks, ecosystem support, and the impact of national programs on their development.
This article compares Elasticsearch and ClickHouse by outlining their architectures, detailing deployment configurations, presenting benchmark queries and performance results, and concluding that ClickHouse generally outperforms Elasticsearch in many basic search and aggregation scenarios, while also noting each system's strengths and limitations.
DeepSpeed Chat provides a fast, affordable, and scalable system for end‑to‑end RLHF training of ChatGPT‑style large language models, offering one‑click scripts, detailed performance benchmarks across GPU configurations, support for many model families, and a flexible API for custom RLHF pipelines.
CeresDB 1.0, the open‑source cloud‑native time‑series database from Ant Group, introduces a next‑generation architecture that supports both traditional and analytical workloads, offers column‑mixed storage, distributed compute‑storage separation, multi‑language SDKs, and demonstrates significant write and query performance gains over InfluxDB in benchmark tests.
This article benchmarks the serialization and deserialization performance of four popular Java JSON libraries—Gson, Fastjson, Jackson, and Json‑lib—using JMH, analyzes the results across different operation counts, and provides guidance on selecting the most suitable library for high‑performance applications.
This article benchmarks Alibaba Cloud Prometheus against the open‑source Prometheus across multiple cluster sizes, churn rates, and query patterns, revealing that while the open‑source version remains stable under light load, its CPU and memory usage grow non‑linearly with high cardinality, whereas Alibaba's managed service delivers higher compatibility, better query performance, and more predictable scaling.
This article compares the open‑source API gateways APISIX and KONG across community activity, plugin richness, performance under various workloads, secondary development flexibility, and their suitability for cloud‑native environments such as Kubernetes ingress and function compute integration.
This article presents a comprehensive overview of StarRocks within the modern data stack, covering the evolution of MPP architectures, typical industry use cases, core features, performance benchmark comparisons, real‑time data‑warehouse construction methods, CDP and lakehouse analytics, as well as short‑term roadmap plans and a brief Q&A.
This article analyzes Baidu's Janus gateway—why it was built despite BFE, its architecture and deployment, three‑layer routing design, variable and condition expression languages, performance benchmarks versus raw Go code, and how its plugin system enables both generic and highly customized traffic‑dispatch solutions.
Alibaba Cloud announced that its ODPS platform has been upgraded into an integrated big‑data solution that supports massive batch jobs, real‑time analytics, and AI workloads, delivering record‑breaking performance and enabling use cases from smart city traffic optimization to accelerated autonomous‑driving model training.
This article examines the data challenges faced by intelligent operations (AIOps), evaluates IoTDB against other time‑series databases through performance benchmarks, outlines Cloudwise's architecture and open‑source contributions, and presents real‑world case studies demonstrating anomaly detection and root‑cause analysis in industrial settings.
This article presents a JMH‑based performance comparison of four popular Java JSON libraries—Gson, FastJson, Jackson, and Json‑lib—covering their Maven dependencies, utility wrappers, a realistic Person model, serialization and deserialization benchmarks, and analysis of the results to guide library selection.
This article details the DPU performance benchmark testing framework, describing three test system architectures—Single-End, End-to-End, and Multi-End—along with their hardware and software components, test workflow, result reporting requirements, and the necessary tools and drivers for accurate and repeatable performance evaluation.
This article details why 360 chose StarRocks as its OLAP engine, presents performance and operational comparisons with MySQL, Hive, Spark, Druid, Doris and ClickHouse, describes three major production use cases, and outlines ongoing explorations such as cloud‑native integration and Kubernetes support.
This article examines ClickHouse’s lack of native upsert and delete operations, explains how ByteHouse’s UniqueMergeTree engine introduces a Mark‑Delete + Insert approach to provide real‑time upsert/delete capabilities, and presents benchmark results showing dramatically faster queries with only modest write overhead.
This article explains the background, concept, advantages, applicable scenarios, technical implementation, and performance evaluation of Elastic Parallel Query (ePQ) in PolarDB MySQL, showing how multi‑node parallelism leverages idle CPU resources, adaptive scheduling, and cloud‑native architecture to accelerate large‑scale analytical workloads while maintaining HTAP capabilities.
ByteHouse, built on ClickHouse, addresses key limitations such as missing upsert/delete, weak multi‑table joins, scalability issues, and lack of resource isolation by introducing a modular, stage‑based execution engine, advanced join strategies, runtime filters, and a custom optimizer, delivering dramatically faster query performance.
The whitepaper introduces a comprehensive DPU performance benchmark methodology, detailing evaluation criteria across network, storage, compute, and security dimensions, and provides guidance on building test systems, selecting workloads, and designing metrics to enable fair, open, and objective assessment of diverse DPU products.
Songguo Mobility’s data‑center team migrated from a fragmented Impala‑Kudu‑ClickHouse stack to a unified StarRocks‑based real‑time OLAP architecture, iterating through three versions to solve scalability, latency, and maintenance challenges while supporting minute‑level dashboards for orders and vehicle analytics.
Phoronix benchmarked OpenJDK versions 8 through 19 alongside OpenJ9 and GraalVM CE on an Intel Core i5‑12600K Ubuntu 22.04 system, revealing varied performance across SciMark, matrix multiplication, LU decomposition, DaCapo, Renaissance, and other tests, with OpenJDK 18/19 often leading in overall scores.
An in‑depth technical overview describes how a WebAssembly‑plus‑QuickJS sandbox architecture enhances web security, improves developer experience, and delivers benchmarked performance gains for next‑generation open web applications, while maintaining compatibility with W3C standards and integrating with existing e‑commerce platforms.
This article explains how Apache Iceberg’s DataSkipping technique can lose efficiency when many filter columns are used, and presents a data‑organization optimization using space‑filling curves and Z‑Order to improve query I/O, details the OPTIMIZE implementation, and shares performance benchmark results and future plans.
This article presents a technical case study of ZhongAn's Jizhi analytics platform, detailing how switching from ClickHouse to the MPP OLAP engine StarRocks resolved multi‑concurrency and join performance bottlenecks, improved real‑time query speed, and enabled near‑billion‑row data handling for insurance business operations.
The article presents a comprehensive performance benchmark of RedisJSON (with RediSearch) against MongoDB and ElasticSearch, showing RedisJSON’s superior write, read, and mixed‑workload throughput and latency across isolated and mixed scenarios, supported by detailed YCSB test results and analysis.
Benchmark tests reveal that RedisJSON, powered by RediSearch, dramatically outperforms MongoDB and ElasticSearch across isolated reads and writes, mixed workloads, and latency metrics, delivering up to 500‑fold speed gains, lower latency, and higher throughput, making it a compelling choice for modern data‑intensive applications.
This article explains the internal mechanics of Unix Domain Sockets, shows how they differ from traditional 127.0.0.1 TCP loopback, provides sample code for server and client, and presents benchmark results demonstrating significantly lower latency and higher throughput for local IPC.
Recent benchmark tests show that RedisJSON, powered by RediSearch, dramatically outperforms MongoDB and ElasticSearch in isolated writes, isolated reads, and mixed workloads, delivering up to 12.7× faster reads, 5.4× faster writes, and significantly lower latency across various operation types.
This article examines why MySQL benchmark results often show low transactions per second on seemingly powerful servers, exploring hidden factors such as network bottlenecks, SSL overhead, and inappropriate sort_buffer_size settings, and provides practical troubleshooting steps and configuration tweaks to achieve optimal performance.
This article describes AutoHome's real‑time data analysis architecture, the challenges of existing OLAP solutions, the reasons for choosing StarRocks, detailed performance comparisons with Kylin, ClickHouse, Doris, Presto and Spark, and the practical integration of StarRocks with Flink, broker‑load scripts, and monitoring tools.
This article reviews deep learning and AI frameworks, highlights challenges of online model serving, and presents Avior—a lightweight, distributed inference engine designed for high‑performance AI services, detailing its architecture, layer design, benchmark results, and future development plans.
Shopee ClickHouse implements a cold‑hot storage architecture by mounting JuiceFS‑backed S3 as a remote volume, using table‑level storage policies and TTL‑driven background moves to shift data from SSD to cold storage, achieving cost‑effective scalability, improved disk utilization, and validated performance despite operational challenges such as Redis memory pressure and small‑file handling.
Java 17, the first LTS release in three years, brings 14 new JEPs, a free Oracle JDK license, and performance gains demonstrated by OptaPlanner benchmarks that show up to 8.66% faster than Java 11, prompting developers to consider upgrading from older versions.
The article explains Java 17’s release as the first LTS since Java 11, details Oracle’s new free JDK license, and presents a thorough OptaPlanner benchmark that compares JDK 11, 16, and 17 using G1GC and ParallelGC, revealing performance gains and guiding upgrade decisions.
This article explains Java 17’s new long‑term‑support release, Oracle’s free JDK licensing, and presents OptaPlanner benchmark results comparing JDK 11, 16 and 17 with G1GC and ParallelGC, highlighting performance gains and migration considerations for developers in production.
This article presents a detailed performance benchmark comparing MariaDB 10.4.12 and MySQL 8.0.19 on an i7 Windows 10 system, covering single and batch inserts, indexed and non-indexed queries, and analyzes speed and memory usage differences between the two databases.
This article compares Elasticsearch and ClickHouse for log analytics, detailing their architectures, presenting a Docker‑Compose test setup that streams synthetic syslog data to both stacks, executing equivalent queries, measuring response times, and concluding that ClickHouse generally delivers faster performance, especially for aggregations.
This article compares Elasticsearch and ClickHouse as log analytics solutions, detailing their architectures, deployment configurations, query capabilities, and performance benchmarks across various query types, and demonstrates that ClickHouse generally outperforms Elasticsearch in speed and aggregation efficiency.
This article details 58 Group's comprehensive evaluation of DorisDB, TiFlash, and ClickHouse for large‑scale analytical workloads, covering functional and performance benchmarks, real‑world use cases such as security analysis and DBA operations, data ingestion methods, cluster architecture, automation practices, and lessons learned.
This article presents a detailed performance benchmark of MariaDB and MySQL, covering single‑row and batch inserts, as well as various query scenarios with and without indexes, and concludes that MariaDB generally outperforms MySQL while using more memory.
This article explains how OceanBase, a distributed relational database, achieved a new TPC‑H world record, discusses the evolution of HTAP technology, the architectural challenges of combining transactional and analytical workloads, and the future direction of the product.
This article explains how NVIDIA's RAPIDS Accelerator leverages GPUs to speed up Apache Spark 3.0 workloads, detailing the underlying architecture, benchmark results on TPC‑DS and recommendation models, required configuration changes, supported operators, shuffle optimizations, and the enhancements introduced in versions 0.2 and 0.3.
Through a series of benchmark tests comparing simple, logging‑enabled microservices written in Java (Helidon) and Go (Go‑Kit), the authors evaluate whether Java can achieve Go‑like performance, exploring JVM tuning, GraalVM native images, and Kubernetes deployments to uncover speed, memory, and scalability trade‑offs.
Zhao Jianbo, head of Kuaishou's big data architecture team, presents an in‑depth overview of Apache Flink's adoption at Kuaishou, covering reasons for selection, development history, business data flows, technical innovations such as the Slimbase state engine, stability improvements, and future roadmap.
The article analyzes recent Docker adoption trends, compares the benefits and overhead of containers and virtual machines, presents benchmark results showing significant performance gains for container workloads on bare‑metal servers and Kubernetes clusters, and discusses implications for hybrid cloud strategies.
This article benchmarks C and Rust by implementing five classic sorting algorithms—Bubble, Insertion, Selection, Shell, and Heap Sort—across three data sizes, analyzes the execution times on a macOS system, and discusses the nuanced performance differences and broader implications for language choice.
This article details Suning's journey of replacing commercial databases with PostgreSQL and Citus, covering background, feature and performance comparisons, reliability tests, deployment architecture, real‑world use cases, operational tips, and a comprehensive Q&A on migration and maintenance.
This article examines Alibaba's FastJson library, benchmarking its speed against Jackson and Gson, analyzing its limited adoption, exposing unresolved issues, and ultimately recommending a shift to more widely supported JSON parsers for Java projects.
BeetlSQL provides a unified, high‑performance database access framework supporting traditional, big‑data, and time‑series databases, outlines its Maven dependency, and presents detailed M3‑phase performance benchmarks across various query methods and ORM tools.
This article evaluates five popular WeChat mini‑program frameworks—WePY, Mpvue, Taro, Uni‑app and Chameleon—by comparing their features, integration costs, performance metrics, and maintainability, and provides recommendations on which framework best fits different development stacks.
OceanBase, Alibaba’s self‑developed distributed relational database, achieved world‑leading TPC‑C performance in 2019 and shattered its own record in 2020, a journey marked by intense team effort, architectural innovations like Paxos‑based scalability, and a vision to become a global database leader.
This article evaluates Taro’s conversion to JD mini‑programs by comparing package size, long‑list rendering benchmarks, and development experience against native JD and WeChat mini‑programs, revealing where Taro excels, where it lags, and the optimizations it provides.
This article examines Alibaba's FastJson library, benchmarks its serialization speed against Jackson and Gson, discusses its popularity and issue count on Maven, and concludes with recommendations for JSON parsing choices in Java projects.
This article presents a detailed MySQL performance benchmark of Alibaba Cloud RDS, Tencent Cloud RDS, and AWS RDS using sysbench, analyzes configuration differences, shows results across mixed, read‑only, and no‑index update workloads, and offers practical recommendations for cloud database tuning.
This article benchmarks several Linux methods for deleting half a million small files—including rm, find with -exec, find with -delete, rsync, Python, and Perl—showing their execution times and concluding that rsync with the --delete option is the quickest and most convenient solution.
This study evaluates Kubernetes container networking options—Docker host networking, Flannel, IPvlan, VXLAN, host‑gw, and AWS‑VPC—by measuring latency, throughput, and installation cost under high‑load conditions, revealing IPvlan as the lowest‑latency, highest‑throughput solution while host‑gw offers a balanced, low‑dependency alternative.
OceanBase’s distributed relational database achieved the top TPC‑C benchmark score by leveraging cloud‑native resources, optimized storage, advanced transaction engines, and extensive SQL tuning, with detailed insights into preparation, system architecture, performance testing phases, ACID compliance, and storage optimizations that set new industry standards.
This article benchmarks the throughput, average latency, median latency, and maximum latency of five RPC frameworks—Dubbo, Motan, rpcx, gRPC, and Thrift—using a unified protobuf‑based service across varying client concurrency levels, and discusses the resulting performance trends and conclusions.
Using JMH, this article benchmarks the serialization and deserialization performance of four popular Java JSON libraries—Gson, Fastjson, Jackson, and Json-lib—by testing various scenarios with a complex Person model, analyzing results, and providing guidance on selecting the most suitable library for high‑performance applications.
This article presents a detailed performance benchmark comparing Apache Storm and Apache Flink in stream processing, focusing on data transmission methods, reliability mechanisms, operator chaining, and both self‑generated and Kafka‑sourced workloads, and provides practical optimization recommendations based on the results.
The article introduces the Mica Java library, explains its core dependencies and recent updates, and presents benchmark comparisons showing Mica’s superior performance in non‑compile‑time bean copying, UUID generation, and date formatting against tools like Hutool, Spring, and CGLIB.
This article benchmarks popular Java bean‑copy tools—including MapStruct, Selma, mica, CGLIB, Spring BeanUtils, and Hutool—under various scenarios such as simple models, type‑conversion, list mapping, and map‑to‑bean conversion, presenting performance scores, error margins, and functional comparisons to help developers choose the most suitable library.
A detailed benchmark comparing Spring Cloud Gateway, Zuul, and Linkerd shows that, contrary to popular belief, Spring Cloud Gateway delivers 1.6 times the throughput of Zuul and even outperforms Linkerd, after correcting earlier testing errors caused by a Reactor Netty bug.
This article introduces the concept, characteristics, and use cases of time series databases, explains the data model and challenges of traditional solutions, and provides a detailed overview of Tencent's Cloud Time Series Database (CTSDB) along with performance comparisons against InfluxDB.
This report presents a systematic performance evaluation of Apache Flink and Apache Storm across multiple real‑time processing scenarios, measuring throughput, latency, message‑delivery semantics, and state‑backend effects, and provides recommendations for selecting the most suitable engine based on the observed results.
This article presents a comprehensive performance evaluation of Apache Flink versus Apache Storm across multiple real‑time processing scenarios, measuring throughput, latency, and the impact of different configurations and delivery semantics to guide framework selection and optimization.
This article evaluates MongoDB and MySQL for storing and querying large‑scale precious‑metal market data, detailing hardware setup, version configurations, schema designs, and extensive performance benchmarks across million‑ to billion‑record datasets, and concludes with analysis of memory architectures, data models, and suitable application scenarios.
This article explains the core functions of relational‑database middleware, dives into Sharding-JDBC’s architecture, performance characteristics, and implementation details such as sharding rules, SQL parsing, routing, rewrite, execution, result merging, and distributed primary‑key generation, and outlines its future roadmap.
A practical benchmark on three identical servers shows MySQL Group Replication achieving higher TPS than Semi‑Sync despite larger network traffic, and explains how Paxos‑based parallel log transmission gives it an edge over the single‑threaded Semi‑Sync approach.
Pilosa, originally built for sparse high‑cardinality user attributes, is evaluated on a dense, low‑cardinality NYC taxi dataset to see if it can serve as a general‑purpose index, with performance comparisons against Spark, PostgreSQL, Elasticsearch, and kdb+ across multiple query scenarios.