Tagged articles
cost estimation
16 articles · Page 1 of 1
The article describes an iterative AI-assisted development workflow where the first version (0.1) is tested and refined through human feedback and regression testing to reach agreed requirements (1.0), emphasizing distinguishing missed requirements from new ones, preserving working features, and measuring effort until the product is truly usable, not just when the agent declares completion.
AI-assisted developmentAgentcost estimation
0 likes · 12 min read

This article examines the latest Nvidia GPU lineup—including A100, H100, A800, H800, and the upcoming H20—detailing their architectures, performance metrics for AI training and inference, cost considerations, and provides a step‑by‑step guide for building a high‑performance compute center.
AI TrainingCompute clusterGPU performance
0 likes · 11 min read

This article examines MySQL slow‑query troubleshooting, explaining how the optimizer estimates costs, why indexes may be ineffective even when present, the impact of memory fragmentation, pitfalls of prefix indexes, index merging techniques, and additional resource‑related factors that can cause seemingly healthy SQL statements to become slow.
Index OptimizationMySQLcost estimation
0 likes · 11 min read

This article examines MySQL's cost estimation process, explains why added indexes may still be ineffective, discusses the impact of memory fragmentation, and presents practical techniques such as prefix index handling, index merging, and resource monitoring to improve slow‑query performance.
Database PerformanceIndex OptimizationMySQL
0 likes · 10 min read

This article provides a detailed technical analysis of NVIDIA's A100, H100, A800, H800 and H20 GPUs, compares their architectures, performance and cost, and offers step‑by‑step guidance on building a private AI compute center, selecting hardware, software stacks and budgeting for different workloads.
AI TrainingGPUNVIDIA
0 likes · 11 min read

This article analyzes a slow Join query on OceanBase 3.2.3.3, examines execution plans and table statistics, proposes two rewrite methods—adding a filter condition and using a hash‑join hint—and demonstrates how these changes reduce execution time from over 500 seconds to just a few seconds.
Database PerformanceNested LoopOceanBase
0 likes · 12 min read

This article explains how MySQL estimates the I/O and CPU costs of different indexes when executing COUNT(*) and other queries, demonstrates the calculations with a concrete example on a 100k‑row table, and shows why the optimizer sometimes picks a full‑table scan over a seemingly better index.
Database PerformanceEXPLAINIndex Optimization
0 likes · 10 min read

The article analyses the computational resources, hardware costs, and human investment needed to train and serve large language models such as GPT‑3, discusses practical cost calculations, highlights the challenges faced by Chinese AI teams, and argues for sustained, long‑term funding to achieve meaningful breakthroughs.
AI infrastructureChina AIcost estimation
0 likes · 14 min read

This article examines how MySQL decides whether to use an index or perform a full table scan for COUNT(*) and other queries, explains the IO and CPU cost model, demonstrates the calculations with a sample table, and shows how optimizer trace can reveal mismatches between estimated and actual performance.
EXPLAINMySQLSQL Performance
0 likes · 10 min read


ITPUBMar 8, 2022 · Databases
This article explains how PostgreSQL generates execution plans, details the plan tree structure, cost parameters, scan and join methods, and provides practical tips for using EXPLAIN, tuning planner settings, and applying hints to optimize SQL performance.
Join TypesPostgreSQLcost estimation
0 likes · 17 min read

This article explains how to use MySQL's EXPLAIN FORMAT=JSON to view detailed execution plan costs, illustrates table structures, walks through two query examples with cost breakdowns, and clarifies the calculation of read_cost and eval_cost for both simple and join queries.
EXPLAINJSONMySQL
0 likes · 10 min read

This article explains the fundamentals of relational optimization, the role of the optimizer, how CPU and I/O costs are estimated, and why accurate database statistics are essential for effective SQL performance tuning.
Database StatisticsPerformance TuningRelational Optimizer
0 likes · 8 min read

This article uses a dialogue‑driven story to explain how PostgreSQL gathers statistics, computes selection rates, evaluates various physical scan and join paths, and combines CPU, I/O, and communication costs—including startup versus total cost—to choose the most efficient execution plan.
Physical PathsPostgreSQLcost estimation
0 likes · 25 min read


ITPUBJul 12, 2016 · Databases
This article walks through practical steps for identifying performance bottlenecks in PostgreSQL, selecting appropriate columns and index types, interpreting system statistics, and evaluating cost estimates with real‑world examples to dramatically reduce query latency.
GiST indexPostgreSQLQuery Performance
0 likes · 13 min read


21CTOMay 14, 2016 · Product Management
This article walks through the full lifecycle of building a modest mobile app in Shenzhen, detailing team composition, office costs, development phases, and a month‑by‑month budget that totals roughly one million RMB for the first version.
App DevelopmentMobile Appbudget
0 likes · 9 min read


21CTOMar 5, 2016 · Mobile Development
This article breaks down the true cost of developing a native mobile app in China, covering developer salaries, team composition, timeline, low‑budget alternatives, template platforms, and when a company should choose a native app versus a Web‑App solution.
AndroidApp DevelopmentChina
0 likes · 10 min read
