SQL Practical Optimization
Introduce several practical SQL optimization techniques.

I am a research-oriented machine learning systems engineer working on foundation model infrastructure, closed-loop evaluation and optimization systems, and scalable AI platforms. My work focuses on building reliable Model-as-a-Service and Harness-as-a-Service platforms that connect data, training, inference, evaluation, and feedback loops into measurable, continuously improving AI products.
My recent work centers on Model-as-a-Service platforms and high-performance LLM inference. I develop serving infrastructure with vLLM and SGLang across model runtime integration, scheduling and continuous batching, KV-cache and memory management, distributed execution, observability, and reliability. This systems work is closely connected to my research on distributed disaggregated inference, preference optimization, instruction-tuning data selection, multimodal evaluation.
My broader research centers on reinforcement learning infrastructure and reinforcement learning optimization algorithms for scalable AI systems. I am interested in how policy optimization, reward modeling, preference learning, offline RL, simulation environments, distributed rollout systems, and automated evaluation harnesses can be engineered together to improve model behavior. My goal is to build frontier AI systems that learn from feedback efficiently, evaluate progress rigorously, and remain dependable when deployed at scale.
Introduce several practical SQL optimization techniques.
The handshake protocol is used to negotiate the security parameters of the connection. The handshake messages are provided to the TLS recording layer, where they are encapsulated …
Gradient descent is a first-order iterative optimization algorithm for finding a local minimum of a differentiable function. To find a local minimum of a function using gradient …
I share my practice 《Application of spatial index in geographic service》. The contents are as follows: - How to understand n-dimensional space and n-dimensional space-time - …
Introduce some basic knowledge of machine learning.
Map is a very common data structure used to store some unordered key-value pairs. In mainstream programming languages, it comes with its implementation by default. STL in C and C++ …
This book is not a systematic study course, but an advanced supplementary book that broadens your horizons, so that readers can access things that are not commonly used in their …
Introduce Functional Reactive Programming, and Functional Reactive Programming impact on programming thinking.
This book is not a systematic study course, but an advanced supplementary book that broadens your horizons, so that readers can access things that are not commonly used in their …