Skip to main content

2 docs tagged with "optimization"

View all tags

DB Profiling

How LZStock guarantees sub-millisecond API latencies by analyzing PostgreSQL execution plans and optimizing composite B-Tree indexes.

Pagination Strategies

How LZStock selects between Offset, Keyset (Cursor), and Database Cursors to balance UI requirements with PostgreSQL B-Tree index performance.