https://sudonull.com/order-by-and-primary-key-in-clickhouse-index-selection
How to correctly choose ORDER BY in ClickHouse: sparse index, column cardinality, equality vs range, verification via EXPLAIN. Rules and examples for gambling.
Search Articles — Sudonull
Search Results
In this project
https://sudonull.com/postgresql-tuning-ai-vs-load-tests
Comparison of AI Recommendations and Real PostgreSQL Benchmarks. Learn how OLTP and OLAP configs affect performance and why tests are more important than theory.
https://sudonull.com/intel-optimization-zone-guides-on-software-tuning
Study Optimization Zone from Intel — repository with recommendations for optimizing Kafka, Redis, Spark on Xeon. Comparison with AMD, Core Series 2 benchmarks. Start tuning servers today.
https://sudonull.com/lags-retry-spring-kafka-how-to-fix
Diagnosis and fix of lags in @RetryableTopic Spring Kafka under load. Increasing scheduler pool solves the problem. Metrics, threaddump, code. For middle/senior dev.
https://sudonull.com/dynamic-arrays-memory-and-performance-optimization-for-developers
Practical strategies for optimizing dynamic arrays: exponential growth, memory reservation, capacity management. Learn how to avoid reallocations and speed up code.
From other projects
https://lrivo.com/portsmouth-s-best-performance-under-mousinho-vs-ipswich
John Mousinho calls Portsmouth's 2-0 win over Ipswich their best display since he took charge. Find out why this could be a turning point in their relegation battle.
https://lrivo.com/how-to-improve-vo2-max-for-endurance-performance-proven-hiit-training-methods
Learn how to improve VO2 max for endurance performance with evidence-based HIIT protocols, weekly training templates, and expert insights from exercise physiology research. Start optimizing your aerobic capacity today.
https://lrivo.com/hearts-fc-performance-fan-debate-after-draw
Hearts FC fans are debating team tactics and performance following a crucial draw. Discover the key concerns and what's next for the league leaders.
https://lrivo.com/arsenal-s-performance-analysis-vs-manchester-city
A look at Arsenal's strong display against Man City and the mindset gap affecting their consistency. Read the key takeaways here.
https://lrivo.com/arsenal-player-analysis-performance-under-title-pressure
Examining Arsenal's recent struggles and how key players are handling pressure during crucial matches. Get insights into their season challenges.
https://lrivo.com/kobbie-mainoo-s-chelsea-performance-defines-man-utd-future
How Kobbie Mainoo's standout display against Chelsea cemented his role at Manchester United and led to a new contract under Michael Carrick.
https://lrivo.com/football-nutrition-shift-performance-sustainability-trends
Explore how elite football diets are evolving, driven by science and influencing sustainability. Learn about the player-fan food disconnect and future trends.
https://lrivo.com/camavinga-s-performance-under-fire-after-real-madrid-loss
Eduardo Camavinga faces intense criticism from Spanish media following Real Madrid's 2-1 defeat to Mallorca. Discover why his play is being scrutinized.
https://lrivo.com/mbappe-s-real-madrid-performance-under-scrutiny
Kylian Mbappé's defensive commitment at Real Madrid is under scrutiny after his return from injury. Learn what Spanish media is saying and what's next for the star forward.
https://lrivo.com/michael-olise-champions-league-performance-analysis-for-bayern-munich
How Michael Olise dominated Real Madrid in the Champions League. Analysis of his assists, dribbling, and why Bayern Munich won't sell their star winger. Read our breakdown.
Trending Now
DeepWay Robotaxi 1000 km: Solid-State Batteries and AI Revolution
Chinese startup DeepWay announced a robotaxi with a range of 1000 km on solid-state batteries. Learn how this changes the electric vehicle market and why it matters.
MongoDB vs PostgreSQL When to Use Each: Key Differences
MongoDB vs PostgreSQL when to use each: compare ACID compliance, scalability, schema flexibility, and query power. Choose the right database for your project.
What Is Object Oriented Programming? Core Concepts Explained
Learn what is object oriented programming, its four pillars, real-world examples, and why it matters for building scalable, maintainable software. Start mastering OOP today.
15 Prompt Engineering Best Practices for Better AI Results
Master prompt engineering best practices with 15 proven techniques. Learn to craft effective prompts, reduce errors, and get better AI results. Start optimizing now.
What Is a Large Language Model? Beginner's Guide
Learn what is a large language model, how AI like ChatGPT works, key capabilities, limitations, and practical uses. Understand LLMs in plain English.
Starlink Launch in Japan: Direct Smartphone Communication via Satellite
SpaceX and KDDI launched satellite communication for smartphones in Japan. Learn how Starlink Direct-to-Cell works, who can access it, and what hidden geopolitical goals this project pursues.
PostgreSQL vs MySQL: Which One to Choose?
PostgreSQL vs MySQL which one to choose? Compare features, performance, scalability, and use cases. Make an informed decision for your project with this data-driven guide.
OWASP Top 10 Explained: What It Is & Why It Matters
Learn what is the OWASP Top 10 and why does it matter for secure coding. A developer's guide to web app vulnerabilities, risks, and practical defense strategies.
What Is a Vector Database? Beginner's Guide to AI Search
What is a vector database? Learn how vector databases power AI search, RAG, and recommendations. Discover key concepts and when to use them. Start here.
Docker Container Networking Explained: A Practical Guide
Docker container networking explained in depth: learn bridge vs host networks, DNS, port publishing, and how to build secure, scalable multi-container apps.