Calpont is pleased to announce high performance sub-query support

Calpont is pleased to announce high performance sub-query support

Rate this post
HomeSubscribePrintE-mailPdf

Calpont is pleased to announce high performance sub-query support with the latest alpha version (1.1.2) of InfiniDB. We’re especially happy about this release because polls done by MySQL have consistently shown – year after year – that slow subquery performance is one of the top items the MySQL community wants fixed in the server. It’s been complex work for sure, but the Calpont engineering team has come through again and delivered high-speed subqueries in only 5 months. Way to go guys!

The latest release includes fully parallel sub-queries including scalar, correlated, 'select clause', and from clause. This was a gap in functionality when Vadim Tkachenko from Percona ran some early benchmarks of InfiniDB (November 2009). Vadim (rightly) commented that InfiniDB needed subquery support, and we listened. The good news is that this functionality is now available, the better news is that the performance is consistent with other queries, and the best news is that the sub-query performance scales as additional cores are available for the system.

  • 2 cores - 12.3 seconds
  • 4 cores -  6.15 seconds
  • 8 cores - 3.34 seconds

Highlights:

  • All of Vadim's sub-query examples are now supported.
  • The sub-queries are fast. The average non-sub-query time with 8 cores was 5.7 seconds (for Vadim's queries). The sub-query statements average 3.35 seconds, again with 8 cores.
  • The sub-queries are scalable. Using query0 as an example, the new sub-queries shows very nice scalability with 2, 4 and 8 cores:

We invite you to download and try out the latest version of InfiniDB with high-speed subquery support. Please let us know what you think and thanks for your support of InfiniDB!