Tagged in sql :
Andrew Houts
The Hidden Cost of Convenience: Rethinking Old ORM Patterns for Scale
Ever been here before? Stuck with a job that needs to be continually revisited because its performance gets worse with every passing day, and each attempt at improving said performance yields diminishing returns? This is the situation we found ourselves in with the portfolio balance calculation system—the code responsible for aggregating data from multiple sources… Read more
Henry Yi
Optimizing Multi-table SQL Queries
Wealthfront’s trading system evaluates hundreds of thousands of client accounts daily for tax-loss harvesting and rebalancing opportunities, requiring high throughput to process all accounts within market hours and low latency to minimize price movement while making investment decisions. In a system with heavy database usage that has low-latency SLA’s such as ours, database queries must… Read more