Database Optimizations
API Optimization So far, we’ve built a simple REST API that exposes basic stock ticker resources, including historical data, tickers, and technical indicators such as SMAs. Our database consists of roughly 25 million rows and has a size of around 2GB. Although the database isn’t exceptionally large, the table sizes are significant enough to warrant exploring database optimizations. Let’s examine our current API response times. Response Times Consider the following endpoint:...