Remove Azure Remove Efficiency Remove Performance Testing Remove Strategy
article thumbnail

Matching Supply With Demand — Solutions, Part 1

SQL Performance

The outer query also computes the trade quantity in the SELECT list as: LEAST ( EndDemand , EndSupply ) - GREATEST ( StartDemand , StartSupply ) If you're using Azure SQL, you can use this expression. It's curious the optimizer chose one strategy for the demand intervals and another for the supply intervals.

Code 116
article thumbnail

Egnyte Architecture: Lessons learned in building and scaling a multi petabyte content platform

High Scalability

Tens of petabytes of data stored in our servers and other object stores such as GCS, S3 and Azure Blobstore. Version5: files metadata in MySQL, files stored in EOS/GCS/S3/Azure and served via HTTP, search in Lucene. Version6: files metadata in MySQL, files stored in EOS/GCS/S3/Azure served via HTTP, search in Elasticsearch.