> "With Clustrix, you never have to worry about database scalability again." That's a huge claim. My two super-basic questions, which I can't find answered on the site, are: 1) Let's say I need to join 100,000 rows in one table to 100,000 rows in another table, all matching ID's and indexed, and then SUM certain values in the second table. If Clustrix has distributed the rows/tables across different machines, how lon…
1) Both joins and aggregates are processed in parallel. In short, the larger your cluster, the faster we evaluate a complex query because we can bring more hardware to the problem. You can get a better idea of how we scale distributed joins from one of my blog posts: http://www.clustrix.com/blog/bid/242790/Scaling-Distributed-... Once we complete the join, we will also perform the aggregate SUM operation across multi…
Re: Clustrix, a distributed SQL DB, launches on AWS
#41How do you handle distributed joins with group by's? Are there certain SQL syntaxes which aren't handled well by queries? What are the 90th percentile response times?