SQL Practical Optimization
Introduce several practical SQL optimization techniques.

I am a research-oriented machine learning systems engineer working on foundation model infrastructure, alignment, and evaluation. My work focuses on building efficient, reliable systems for large language models while studying the algorithms and data choices that make these models more useful, controllable, and cost-effective in real applications.
At TikTok, 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, and retrieval-augmented biomedical summarization.
My broader research spans reinforcement learning for robotics, healthcare sequence modeling, privacy-preserving machine learning, and motion planning. I am especially interested in model-system co-design: how model architecture, inference algorithms, data curation, hardware utilization, scheduling, and distributed runtimes interact. My goal is to advance frontier AI systems that are faster to experiment with, more rigorous to evaluate, and dependable enough to serve 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 …