3 ms·
Ask yourself the same question about an OLAP system. Once you’re at a large enough scale, it makes sense to use tools custom designed for your access patterns.
by beoberha 3y ago
Ask yourself the same question about an OLAP system. Once you’re at a large enough scale, it makes sense to use tools custom designed for your access patterns.
I work on Azure SQL, but it’s pretty clear that this is a cool demo. It may scale for some usages, but I wouldn’t build a production system on it.
- sabareesh 3y agoWell tried it with ~ 34 million records , which is good enough sample for our usecase
- marcinzm 3y agoAt what number of queries per second?
- bob1029 3y ago> Azure SQL > large enough scale You mean something like the Hyperscale service tier? This is what we are building our new products on top of.
- beoberha 3y agoHyperscale is awesome. My point is more for vector search. Once you’re at a large enough scale, the simple algorithms for similarity search break down. You’d need something that implements HNSW and designed their database indexes around it.